MySQL data type "Summary"

1. Time Type

MySQL's Date,datetime,timestamp and time data types.

A datetime type is used when you need a value that contains both date and time information. MySQL retrieves and displays the datetime value in ' yyyy-mm-dd HH:MM:SS ' format, supported by ' 1000-01-01 00:00:00 ' to ' 9999-12-31 23:59:59 '. ("support" means that although earlier values may work, there is no guarantee that they can.) ）

The date type is used when you only need a date value, and there is no time section. MySQL retrieves and displays the date value in ' YYYY-MM-DD ' format, supported by ' 1000-01-01 ' to ' 9999-12-31 '.

The timestamp column type provides a type that you can use to automatically mark an INSERT or update operation with the current date and time.

The time data type represents the times of the day. MySQL retrieves and displays the time value in the "HH:MM:SS" format. The supporting fan circumference is ' 00:00:00 ' to ' 23:59:59 '.

2.

Not to be continued ...

MySQL data type "Summary"