Purpose
mysql.time_zone_transition_type displays information about time zone conversion types. It is a system view.
Related tables/views
__all_time_zone_transition_type
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| Time_zone_id | bigint(20) | NO | The ID of the time zone. |
| Transition_type_id | bigint(20) | NO | The ID of the time zone conversion type. |
| Offset | bigint(20) | NO | The time zone offset. |
| Is_DST | bigint(20) | NO | Indicates whether it is the Daylight Saving Time (DST). |
| Abbreviation | varchar(8) | NO | The abbreviation. |