15.10 - time_zone_string - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.