Webmaster2020.com

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:

Incorrect date value: '0000-00-00' for column

Even delete doesn't work:

DELETE FROM table WHERE start_date='0000-00-00';

How do I fix this?

Posted: **Thu Apr 23, 2020 6:59 am**

The error is because MYSQL is in strict mode (default)

You can Check MYSQL mode

SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session

You change it with the following query;

SET sql_mode = '';

or

SET GLOBAL sql_mode = '';

Using the keyword GLOBAL requires super privileges and it affects the operations all clients connect from that time on !

Posted: **Thu Apr 23, 2020 9:46 am**

Thanks that solved it

Solved: Incorrect date value: '0000-00-00' for column