[INTERLINKED-27] CONVERT_TZ not recognizing US timezones
It's been reported that in some pages, dates are mostly showing as all 0s.
This appears to occur when the user's time zone is stored as a US/ type time zone, e.g. US/Eastern. In new versions of MariaDB, the time zone import does not include US/Eastern, US/Central, etc. - only the canonical time zones, e.g. America/New_York.
This appears to be due to an underlying difference in the zone info available on newer Debian systems:
Old database server:
MariaDB [(none)]> SELECT COUNT(*) FROM mysql.time_zone_name;
+----------+
| COUNT(*) |
+----------+
| 1790 |
+----------+
MariaDB [(none)]> SELECT * FROM mysql.time_zone_name WHERE Name LIKE 'US/%';
+-------------------+--------------+
| Name | Time_zone_id |
+-------------------+--------------+
| US/Alaska | 580 |
| US/Aleutian | 581 |
| US/Arizona | 582 |
| US/Central | 583 |
| US/East-Indiana | 584 |
| US/Eastern | 585 |
| US/Hawaii | 586 |
| US/Indiana-Starke | 587 |
| US/Michigan | 588 |
| US/Mountain | 589 |
| US/Pacific | 590 |
| US/Samoa | 591 |
+-------------------+--------------+
12 rows in set (0.001 sec)
6.1.0-26-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.112-1 (2024-09-30) x86_64 GNU/Linux
/usr/share/zoneinfo# ls
Africa Australia Cuba Etc GMT+0 Iceland Kwajalein NZ Poland UCT Zulu posixrules
America Brazil EET Europe GMT-0 Indian Libya NZ-CHAT Portugal US iso3166.tab right
Antarctica CET EST Factory GMT0 Iran MET Navajo ROC UTC leap-seconds.list tzdata.zi
Arctic CST6CDT EST5EDT GB Greenwich Israel MST PRC ROK Universal leapseconds zone.tab
Asia Canada Egypt GB-Eire HST Jamaica MST7MDT PST8PDT Singapore W-SU localtime zone1970.tab
Atlantic Chile Eire GMT Hongkong Japan Mexico Pacific Turkey WET posixNew database server:
MariaDB [(none)]> SELECT COUNT(*) FROM mysql.time_zone_name;
+----------+
| COUNT(*) |
+----------+
| 486 |
+----------+
MariaDB [(none)]> SELECT * FROM mysql.time_zone_name WHERE Name LIKE 'US/%';
Empty set (0.000 sec)
6.12.48+deb13-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.48-1 (2025-09-20) x86_64 GNU/Linux
/usr/share/zoneinfo# ls
Africa Antarctica Asia Australia Europe GMT Pacific iso3166.tab leapseconds posixrules zone.tab zonenow.tab
America Arctic Atlantic Etc Factory Indian UTC leap-seconds.list localtime tzdata.zi zone1970.tabComments
You must be logged in to leave a comment.