客户端连接时时区是根据当前连接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