General Rules for Using SET TIME ZONE - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

The following rules apply to using SET TIME ZONE.

  • You can set the default time zone for a session or user by specifying either a numeric offset from UTC or by specifying a time zone string literal.
  • The range of time zone displacements permissible is -12:59 through +14.00 inclusive.
  • The form for time zone displacement values is always INTERVAL HOUR TO MINUTE.
  • The time zone string is associated with a session or user, not a time zone displacement. When a time zone displacement is needed in a request, that string plus a TIMESTAMP value or a TIME value, depending on which is appropriate, is used to determine the time zone displacement needed for a particular usage.