插入日期有时会插入全部0

Question

i have a column in my database for the date a new record was added, it's set with the following code:

    $dateset = date("Y-m-d");
    $q = "INSERT INTO appts (date_set) VALUES ('$dateset')";

this is working about 80% of the time, is there any reason that randomly it will add the date as "0000-00-00"?

Answer 1

You should check type of field 'date_set'.

• if type is DATE you have to use:

    $dateset =  date("Y-m-d");

• if type is DATETIME you have to use:

    $dateset =  date("Y-m-d H:i:s");
    //It is correct, but database push after time 00:00:00 (but it depends on the settings of the database)
    //$dateset =  date("Y-m-d"); 

• if type is TIMESTAMP you have to use:

    $dateset =  time();

Try use sql:

    $q = "INSERT INTO appts (date_set) VALUES (NOW())";