PHP date() format when inserting into datetime in MySQL
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.