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 |
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.