The difference between the date datetime time timestamp in MySQL

Data types for time in MySQL: They are date, datetime, hour, timestamp, year

Date: "Yyyy-mm-dd" dates
1000-01-01 to 9999-12-31 3 bytes

Time: "Hh:mm:ss"
-838:59:59 to 838:59:59 3 bytes

DateTime: "Yyyy-mm-dd hh:mm:ss" date + time
1000-01-01 00:00:00 to 9999-12-31 23:59:59 8 bytes

Timestamp: Time stamp

Sometime from 1970-01-01 to 2037.4 bytes

Year: "YYYY" years
1901 to 2155 1 bytes

datetime, timestamp two datetime types have advantages: DateTime has a large date range, and timestamp occupies less storage space, only half of the DateTime.

The difference between the date datetime time timestamp in MySQL