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

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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.