mysql utc毫秒值_为什么要用毫秒值的形式存储日期时间？

passerbytiny

2019-04-02 08:50:28 +08:00

@richard1122 #33 你是从哪里看出来 DATETIME 是时间戳存储的，自己阅读能力有限，请不要误导人。

DATE DATETIME 是年月日时分秒+纳秒值格式，TIMESTAMP 是时间戳的格式。你就算没看懂 “ MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format.” 这句话，看到'1000-01-01 00:00:00' to '9999-12-31 23:59:59'这种范围，也不应该认为它是时间戳。

The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format. The supported range is '1000-01-01' to '9999-12-31'.

The DATETIME type is used for values that contain both date and time parts. MySQL 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'.

MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such as DATETIME.)