The mysql.time_zone table assigns a unique ID to each time zone supported by the server, linking to other time zone system tables.
The mysql.time_zone table is one of the mysql system tables that can contain time zone information. It is usually preferable for the system to handle the time zone, in which case the table will be empty (the default), but you can populate the mysql time zone tables using the mariadb-tzinfo-to-sql utility. See Time Zones for details.
This table uses the Aria storage engine.
The mysql.time_zone table contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
Time_zone_id
int(10) unsigned
NO
PRI
NULL
ID field, auto_increments.
Use_leap_seconds
enum('Y','N')
NO
N
Whether or not leap seconds are used.
SELECT * FROM mysql.time_zone;
+--------------+------------------+
| Time_zone_id | Use_leap_seconds |
+--------------+------------------+
| 1 | N |
| 2 | N |
| 3 | N |
| 4 | N |
| 5 | N |
| 6 | N |
| 7 | N |
| 8 | N |
| 9 | N |
| 10 | N |
...
+--------------+------------------+