#1292 - Incorrect date value: '0000-00-00'

You have 2 options to make your way:

Select NULL from the dropdown to keep it blank.
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.

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.

Tags:

Mysql

Sql

Date

Phpmyadmin

Related