time-zone-specification1.md
Specifying time zones
You can specify time zones in two ways:
-
A string literal such as
America/Chicago
orPST
-
An interval that specifies a UTC offset—for example,
INTERVAL '-08:00'
It is generally good practice to specify time zones with literals that indicate a geographic location. Vertica makes the necessary seasonal adjustments, and thereby avoids inconsistent results. For example, the following two queries are issued when daylight time is in effect. Because the local UTC offset during daylight time is -04
, both queries return the same results: