16.20 - TIME ZONE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Default time zone displacement for the specified user.

For descriptions of these options, see “MODIFY USER” in Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 .

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.