Example: Modifying Time Zone Displacement with TIME ZONE time_zone_string Option - Teradata Vantage

This statement changes the time zone displacement for user pa from to the time zone displacement defined by the string 'America Pacific'.

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 time_zone_string is invalid, Vantage returns an error to the requestor.