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.