15.10 - TIME ZONE - 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

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.