MYSQL 8 : SQL Mode for Datetime invalid?

Question

I know, it's ugly but things used to work and we can't change this :

#1525 - Incorrect DATETIME value: ''

For a query

SELECT * FROM table WHERE date_change=''

Is there a SQL mode for MySQL 8? Or any idea?

Answer 1

see: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_no_zero_in_date

If sql_mode has 'NO_ZERO_IN_DATE' then you cannot have a zero_date (or datetime).

Answer 2

SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_IN_DATE', '');

will do it