# mysql.time\_zone\_transition Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.time_zone_transition` table is one of the `mysql` system tables that can contain [time zone](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/time-zones) 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](https://mariadb.com/docs/server/clients-and-utilities/administrative-tools/mariadb-tzinfo-to-sql) utility. See [Time Zones](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/time-zones) for details.

This table uses the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) storage engine.

The `mysql.time_zone_transition` table contains the following fields:

| Field                | Type             | Null | Key | Default | Description |
| -------------------- | ---------------- | ---- | --- | ------- | ----------- |
| Time\_zone\_id       | int(10) unsigned | NO   | PRI | NULL    |             |
| Transition\_time     | bigint(20)       | NO   | PRI | NULL    |             |
| Transition\_type\_id | int(10) unsigned | NO   |     | NULL    |             |

## Example

```sql
SELECT * FROM mysql.time_zone_transition;
+--------------+-----------------+--------------------+
| Time_zone_id | Transition_time | Transition_type_id |
+--------------+-----------------+--------------------+
|            1 |     -1830383032 |                  1 |
|            2 |     -1640995148 |                  2 |
|            2 |     -1556841600 |                  1 |
|            2 |     -1546388400 |                  2 |
|            2 |     -1525305600 |                  1 |
|            2 |     -1514852400 |                  2 |
|            2 |     -1493769600 |                  1 |
|            2 |     -1483316400 |                  2 |
|            2 |     -1462233600 |                  1 |
|            2 |     -1451780400 |                  2 |
...
+--------------+-----------------+--------------------+
```

## See Also

* [mysql.time\_zone table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone-table)
* [mysql.time\_zone\_leap\_second table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_leap_second-table)
* [mysql.time\_zone\_name table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_name-table)
* [mysql.time\_zone\_transition\_type table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_transition_type-table)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}