Error code:1067 about the date time in the MySQL database. Invalid default value for XXX)

An error message suddenly appears when you create a new table:

Error code:1067. Invalid default value for ' Start_time '

After some tossing and finding that it is DateTime cannot set the default value, so if you want to set the default value, we can also use timestamp and then set the default value of Current_timestamp.

However, in addition to setting the default values in the database, we can also set in the program, if it is 5.6 of the MySQL database should not have the default value can not set the problem

Error code:1067 about the date time in the MySQL database. Invalid default value for XXX)