第一个没明白你的意思,好绕,说实际场景,为何要那么做
第二个:MySQL 用 TIMESTAMP
作为日期字段的类型, TIMESTAMP
保存的时候,MySQL 会转换成 UTC 来存储:
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.)