Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
N/A
-
None
-
MariaDB 10.4.26
Description
Mexico aborted DST for Mexico City and most of Mexico. There won't be DST changes in 2023.
CONVERT_TZ still has DST for "America/Mexico_City" timezone.
MariaDB [mysql]> SELECT CONVERT_TZ('2023-01-01 00:00:00','UTC','America/Mexico_City'); |
+---------------------------------------------------------------+
|
| CONVERT_TZ('2023-01-01 00:00:00','UTC','America/Mexico_City') | |
+---------------------------------------------------------------+
|
| 2022-12-31 18:00:00 | |
+---------------------------------------------------------------+
|
1 row in set (0.012 sec) |
 |
MariaDB [mysql]> SELECT CONVERT_TZ('2023-05-01 00:00:00','UTC','America/Mexico_City'); |
+---------------------------------------------------------------+
|
| CONVERT_TZ('2023-05-01 00:00:00','UTC','America/Mexico_City') | |
+---------------------------------------------------------------+
|
| 2023-04-30 19:00:00 | |
+---------------------------------------------------------------+
|
1 row in set (0.000 sec) |
Tested with latest time zone tables that were retrieved from here: https://mariadb.com/kb/en/time-zones/#mysql-time-zone-tables
Some related links: https://www.timeanddate.com/news/time/mexico-abolishes-dst-2022.html
https://www.timeanddate.com/news/time/mexico-time-zone-change-2022.html
Attachments
Issue Links
- relates to
-
MDBF-389 provide timezone data files
-
- Closed
-