Note
This view was introduced in OceanBase Database V2.1.
Purpose
The mysql.time_zone_transition_type view displays the information about time zone conversion types. It is a system view.
Columns
| Column | 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 the time is the Daylight Saving Time (DST). |
| Abbreviation | varchar(8) | NO | The abbreviation of the time zone. |