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.