15.10 - time_zone_string - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
English (United States)
Last Update

Sets the value of the default time zone for the session to the displacement specified by ‘time_zone_string’.

If you specify an explicit non-GMT time zone string, it is passed to a system-defined UDF named GetTimeZoneDisplacement that interprets the string and determines the appropriate time zone displacement for the session (see SQL Functions, Operators, Expressions, and Predicates, B035-1145 for information about this system-defined UDF). Time zone strings that are expressed in terms of GMT do not enable automatic adjustments for Daylight Savings Time.

To set system-wide time zone values, you must use the DBS Control parameters SystemTimeZoneHour and SystemTimeZoneMinute (see Utilities: Volume 1 (A-K)) or the tdlocaledef utility (see Utilities: Volume 2 (L-Z)).

See “SET TIME ZONE” in SQL Data Definition Language - Detailed Topics, B035-1184 for a complete list of the supported time zone strings.

Example: Setting the Time Zone Using a Time Zone String

This example sets the session default time zone displacement by specifying a simple constant time zone string expression. Teradata Database then passes the string to a system-defined UDF that interprets it and sets the default time zone displacement for the session based on the value of the string.

     SET TIME ZONE 'America Eastern';

If the value of the time_zone_string you specify is not valid, the request aborts and Teradata Database returns the following error to the requestor.

     *** Failure 7455 Invalid Time Zone specified.