Details
Description
On Windows, the global variable system_time_zone doesn't properly reflect the used time zone when the environment variable TZ is set.
For example, on my system configured for region Germany, but TZ is set as "CST-8":
SELECT @@time_zone, @@system_time_zone, TIMEDIFF(NOW(), UTC_TIMESTAMP());
SYSTEM Europe/Berlin 08:00:00
Whereas in Linux it returns
SYSTEM CST 08:00:00
Attachments
Issue Links
- is caused by
-
MDEV-19243 Fix timezone handling on Windows to report POSIX timezone names
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
9d 20h 38m | 1 |
|
31d 12h 31m | 1 |
|
47d 12h 9m | 1 |
|
6h 20m | 1 |