17.05 - Example: Modifying Time Zone Displacement with TIME ZONE time_zone_string Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
Last Update
2021-01-22

This statement changes the time zone displacement for user pa from whatever it had been to the time zone displacement defined by the string 'America Pacific' using the TIME ZONE = ‘time_zone_string’ option.

Vantage passes the specified time zone string to a system-defined UDF that validates it. The UDF is also called to retrieve the rules associated with the time zone string whenever pa logs on.

     MODIFY USER pa AS 
     TIME ZONE = 'America Pacific';

If the value of the time_zone_string you specify is not valid, Vantage returns an error to the requestor.