MySQL的每个连接都有独立的时区设置，初始基于全局时区。时区设置影响NOW()、CURTIME()等函数显示及TIMESTAMP列的存储与读取，TIMESTAMP值在存储和检索时会与当前时区进行转换。UTC_TIMESTAMP()、DATE、TIME、DATETIME列不受当前时区影响，它们不存储为UTC。若要进行日期时间的本地化运算，需先转换为UTC，运算后再转换回来。
客户端连接时时区是根据当前连接session时区设置，并且只会影响函数和timestamp存取；时区设置不影响UTC_TIMESTAMP()函数和DATE、TIME、DATETIME数据列。
Per-connection time zones. Each client that connects has its own time zone setting, given by the session time_zone variable. Initially, the session variable takes its value from the global time_zone variable, but the client can change its own time zone with this statement:
mysql> SET time_zone = timezone;
The current session time zone setting affects display and storage of time values that are zone-sensitive. This includes the values displayed by functions such as NOW() or
最低0.47元/天 解锁文章
4195
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
