MySQL Time storage type pros and cons? Datetime? Timestamp?int?

TIMESTAMP

4 bytes of storage; values are saved in UTC format;. Time zone conversion, which transforms the current time zone when it is stored, and then converts it back to the current time zone.

Datetime

8 bytes stored, actual format stored, time-zone independent, DateTime retrieves and displays datetime values in ' yyyy-mm-dd HH:MM:SS ' format. The supported range is ' 1000-01-01 00:00:00 ' to ' 9999-12-31 23:59:59 ' timestamp value cannot be earlier than 1970 or later than 2037

Int

Save time stamp. Low resource usage and fast query speed. Condition range Search using between no problem. Query conditions free splicing.

DateTime and timestamp have a small advantage over int, which means that there are a number of time functions that can be used for a time type.

MySQL Time storage type pros and cons? Datetime? Timestamp?int?