PHP date() format when inserting into datetime in MySQL

Asked 2010-02-07T00:27:02.397

413

What is the correct format to pass to the date() function in PHP if I want to insert the result into a MySQL datetime type column?

I've been trying date('Y-M-D G:i:s') but that just inserts "0000-00-00 00:00:00" everytime.

php mysql

Edit Report

1 Answer

840

The problem is that you're using 'M' and 'D', which are a textual representations, MySQL is expecting a numeric representation of the format 2010-02-06 19:30:13

Try: date('Y-m-d H:i:s') which uses the numeric equivalents.

edit: switched G to H, though it may not have impact, you probably want to use 24-hour format with leading 0s.

answered 2010-02-07T00:29:56.640

PHP date() format when inserting into datetime in MySQL

1 Answer

Your Answer