About the three date types in Mysql

After two insert date types recently, the value is 0000-00-00 00:00:00, so I checked the official documentation and found the reason.

In Mysql, we often use three data types to store dates: Date, Datetime, and Timestamp.

The Date data type is used to store dates without time. Mysql gets and displays this type in the format of YYYY-MM-DD ". The supported time range is "1000-00-00" to "9999-12-31 ".

Datetime stores data with both date and time. The storage and display format is YYYY-MM-DD HH: MM: SS ". The supported time range is "1000-00-00 00:00:00" to "9999-12-31 23:59:59 ".

The Timestamp type also stores data with both dates and time. The storage and display formats are the same as those of Datetime. The supported time range is "00:00:01" to "03:14:07 ".

All data that does not conform to the preceding format will be converted to a value of 0 of the corresponding type. (Or 0000-00-00 00:00:00)