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

[maketopsite]

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]

Why do you post this question in multiple forums?
You have already got answer here.

[maketopsite]

Why do you post this question in multiple forums?
You have already got answer here.

Because I believe it increases probability of getting best answer (and faster). (I've posted it at same moment which I see is not apparent because this forum does not show exact time of posting)