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