Incorrect datetime value error 1292 in MySQL 5.7, allow to use empty value in date fields.

africz · Posted on

Original my.cnf had sql_model set as follows:

sql_mode=STRICT_TRANS_TABLES,ALLOW_INVALID_DATE...etc

Remove STRICT_TRANS_TABLES and restart service, it will allow to use empty values in date fields. Use ” ALLOW_INVALID_DATE ” seems not enough to eliminate error message.