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
What is please optimal solution ?
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
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;