I'm trying to update my datetime field in a table with the following PHP datetime:
$datetime = date('d/m/Y H:i:s');
Unfortunately the datetime field in the table is NULL
How can I update a datetime field with $datetime ?
Thanks
Add a comment
|
3 Answers
right format is Y-m-d H:i:s anyway in your SQL query you can use NOW()
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_now
1 Comment
pregmatch
You can also instead of now() use current_timestamp in mysql query.
$datetime = date('Y-m-d H:i:s');
will work. DATETIME columns must be in a Y-m-d H:i:s format, not d-m-Y H:i:s.
From the manual:
The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format.
Comments
The correct format is Y-m-d H:i:s.
answered Nov 30, 2012 at 20:24
Niet the Dark Absol
326k86 gold badges480 silver badges604 bronze badges