Solved: Incorrect date value: '0000-00-00' for column
Posted: Wed Apr 22, 2020 7:18 pm
Hi,
somehow there are is a "bad" date in the table ( 0000-00-00' ),
It tried to update it to another value
but each time I get the error-message:
Even delete doesn't work:
How do I fix this?
somehow there are is a "bad" date in the table ( 0000-00-00' ),
It tried to update it to another value
but each time I get the error-message:
Code: Select all
Incorrect date value: '0000-00-00' for column
Code: Select all
DELETE FROM table WHERE start_date='0000-00-00';