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.