Time Zone Names for Setting TIME ZONE
The time zone names listed in the table below are recognized by Vertica as valid settings for the SQL time zone (the TIME ZONE run-time parameter).
Time zone and daylight-saving rules are controlled by individual governments, and are subject to change. For the latest information, see Sources for Time Zone and Daylight Saving Time Data.
These names are not the same as the names shown in /opt/vertica/share/timezonesets, which are recognized by Vertica in date/time input values. The TIME ZONE names shown below imply a local daylight-savings time rule, where date/time input names represent a fixed offset from UTC.
In many cases, the same zone has several names. These are grouped together. The table is primarily sorted by commonly used zone names.
In addition to the names listed in the table, Vertica accepts time zone names as one of the following:
- STDoffset
- STDoffsetDST
where STD is a zone abbreviation, offset is a numeric offset in hours west from UTC, and DST is an optional daylight-savings zone abbreviation, assumed to stand for one hour ahead of the given offset.
For example, if EST5EDT were not already a recognized zone name, it would be accepted and would be functionally equivalent to USA East Coast time. When a daylight-savings zone name is present, it is assumed to be used according to USA time zone rules, so this feature is of limited use outside North America.
Be aware that this provision can lead to silently accepting invalid input, as there is no check on the reasonableness of the zone abbreviations. For example, SET TIME ZONE TO FOOBANKO works, leaving the system effectively using a rather peculiar abbreviation for GMT.
|
Time Zone |
|---|
|
CET |
|
EET |
|
Factory |
|
GMT |
|
MET |
|
UCT Etc |
|
UTC Universal Zulu |
|
WET |