16.20 - General Rules for Using SET TIME ZONE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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.