mysql: ERROR 1292 (22007): Incorrect date value: '0000-00-00'
by MakeTopSite from LinuxQuestions.org on (#6KZDG)
Code: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 1Server version: 8.0.26 MySQL Community Server - GPL
What is please optimal solution ?
ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'some_date_column' at row 1Server version: 8.0.26 MySQL Community Server - GPL
What is please optimal solution ?