Time Zone Names for Setting TIME ZONE

The following time zone names are recognized by Vertica as valid settings for the SQL time zone (the TIME ZONE run-time parameter).

Note: The names listed here are for convenience only and might be out of date. Refer to the Sources for Time Zone and Daylight Saving Time Data page for precise information.

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 casesthje 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 of the form STDoffset or 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 wary that this provision can lead to silently accepting bogus input, since 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

Africa

America

Antarctica

Asia

Atlantic

Australia

CET

EET

Etc/GMT

Europe

Factory

Etc/GMT

   GMT
   GMT+0
   GMT-0
   GMT0
   Greenwich
   Etc/Greenwich

Indian

MET

Pacific

UCT Etc
UCT

UTC

   Universal Zulu
   Etc/UTC
   Etc/Universal
   Etc/Zulu

WET