Search code examples
mysqlsqlyog

Warning Code : 1264 Out of range value for column for datetime column value

Here's my query:

UPDATE lynn_mis_goodsales SET accepteddate = '2011-02-30 13:24:50' WHERE created LIKE '0000-00-00 00:00:00'

The column value is datetime, and the error given is:

Warning Code : 1264
Out of range value for column 'accepteddate'

What can be the reason for this error when I use SQLYog?

Solution

  • I could be wrong, but it looks like your date is February 30, which will cause an error since that date does not exist anywhere I'm aware of :)