Share this page

# TIMEZONE_INFO

This table stores all major timezones and the daylight saving start and end date information. This table is under the schema that contains management tables.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Field Name | Null? | Field Type | Description
--- | --- | --- | ---
TIMEZONE_ID | Not null | VARCHAR(200) | Unique label for the timezone, such as `Asia/Shanghai`
YEAR | Not null | INT | The year with active Vertica for PPM function
DST_START_DATE_UTC | Nullable | timestamp | Daylight saving start date for UTC time
DST_END_DATE_UTC | Nullable | timestamp | Daylight saving end date for UTC time
DST_START_DATE_LOC | Nullable | timestamp | Daylight saving start date for local time
DST_END_DATE_LOC | Nullable | timestamp | Daylight saving end date time for local time
BASE_UTC_OFFSET | Not null | int | Time gap with UTC
DST_VALUE | Nullable | int | Time gap introduced by daylight saving
DST_ENABLED | Nullable | varchar(2) | Whether daylight saving is enabled; supported values are`Y` or`N`
MD_CREATETIME | Nullable | datetime | Date when the record is created
MD_LASTMODDDATE | Nullable | datetime | Date when the record is updated

## Projections

This table uses no projections.

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: