General Rules for Using SET TIME ZONE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
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.