SET TIME ZONE
Changes the TIME ZONE run-time parameter for the current session. Use SHOW TIMEZONE
to show the session's current time zone.
If you set the timezone using POSIX format, the timezone abbreviation you use overrides the default timezone abbreviation. If the date style is set to POSTGRES, the timezone abbreviation you use is also used when converting a timestamp to a string.
Syntax
SET TIME ZONE TO { value | 'value' }
Note: Vertica treats literals TIME ZONE
and TIMEZONE
as synonyms.
Parameters
value |
One of the following:
|
Privileges
None
Examples
=> SET TIME ZONE TO DEFAULT; => SET TIME ZONE TO 'PST8PDT'; -- Berkeley, California => SET TIME ZONE TO 'Europe/Rome'; -- Italy => SET TIME ZONE TO '-7'; -- UDT offset equivalent to PDT => SET TIME ZONE TO INTERVAL '-08:00 HOURS';