The default date 0000-00-00 error in MySQL

DEFAULT CONSTRAINT for DATES

20th Oct 2022 SHAFI SHAIK

Default dates in legacy systems, particularly MySQL, were set to 0000-00-00. From version 5.6 on, MySQL stopped allowing users to enter these values without first

MySQL Error 1067 – Invalid default value for Date

14th Oct 2022 SHAFI SHAIK

You may have noticed that date columns’ default dates in legacy systems are 0000-00-00. The data cannot be changed, therefore you’ll have to accept it.