[SOLVED] mysql: ERROR 1292 (22007): Incorrect date value: '0000-00-00'

[MakeTopSite]

Code: Select all

mysql> UPDATE some_table SET some_date_column='2024-04-10' WHERE some_date_column='0000-00-00' ;
ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'some_date_column' at row 1

Server version: 8.0.26 MySQL Community Server - GPL

What is please optimal solution ?

[ruwolf]

MySQL: sql_mode: NO_ZERO_DATE
MariaDB: sql_mode: NO_ZERO_DATE

[MakeTopSite]

MySQL: sql_mode: NO_ZERO_DATE
MariaDB: sql_mode: NO_ZERO_DATE

Thank you, it's solved by

Code: Select all

UPDATE some_table SET some_date_column='2024-04-10'
WHERE some_date_column IS NULL;