Purpose
The V$TIMEZONE_NAMES view displays the valid time zone names.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TZNAME | varchar(64) | NO | The name of the time zone. |
| TZABBREV | varchar(8) | NO | The abbreviation of the time zone, such as PDT. |
| CON_ID | decimal(38,0) | NO | The ID of the tenant. |