Default time zone displacement for the specified user.
For descriptions of these options, see “MODIFY USER” in SQL Data Definition Language Detailed Topics.
You can specify:
- LOCAL
- NULL
- ± ‘quotestring’
- ‘time_zone_string’
Example: Modifying the Time Zone Displacement With the TIME ZONE LOCAL Option
This example changes the time zone displacement for user_name from whatever it had been to the time zone defined as the system default.
MODIFY USER user_name AS
TIME ZONE = LOCAL;
Example: Modifying the Time Zone Displacement With the TIME ZONE time_zone_string Option
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.
Teradata Database 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, Teradata Database returns an error to the requestor.