MySQL time Type Selection

Inter-Domain type:Try to use the timestamp type, because its storage space only needs half of the datetime type. For data types that only need to be accurate to a specific day, we recommend that you use the date type because its storage space only needs three bytes, which is less than timestamp. It is not recommended to store a Unix timestamp value through the int type class, because this is too intuitive, it will bring unnecessary trouble for maintenance, but also will not bring any benefits.