#1292 - Incorrect date value: '0000-00-00' [duplicate] #1292 - Incorrect date value: '0000-00-00' [duplicate] sql sql

#1292 - Incorrect date value: '0000-00-00' [duplicate]


The error is because of the sql mode which can be strict mode as per latest MYSQL 5.7 documentation.

For more information read this.

Hope it helps.


You have 3 options to make your way:
1. Define a date value like '1970-01-01'
2. Select NULL from the dropdown to keep it blank.
3. Select CURRENT_TIMESTAMP to set current datetime as default value.


After reviewing MySQL 5.7 changes, MySql stopped supporting zero values in date / datetime.

It's incorrect to use zeros in date or in datetime, just put null instead of zeros.