Modifying the Default Time Zone for a User - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

When you assign a default time zone to a user, each time that user logs onto Vantage, their session uses the assigned time zone offset.

The valid range for a time zone offset specified as ± ‘quotestring’ is from -12:59 to +14.00.

If you set the default time zone offset for a user by specifying a non-GMT time zone string, Vantage can change the time zone automatically whenever there is a change in Daylight Saving Time. Only those time zone strings that are not defined in terms of GMT enable automatic adjustments for Daylight Saving Time. The GMT time zone strings are designed to be used for regions and time zones that do not follow Daylight Saving Time.

See SET TIME ZONE in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144 for a comprehensive list of the valid time zone strings that you can use to set the time zone offset for a user and Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211 for the definition of the GetTimeZoneDisplacement UDF that converts time zone values when Daylight Saving Time changes.

See Teradata Vantage™ - Database Utilities, B035-1102 for information about the DBS Control flags SystemTimeZoneHour, SystemTimeZoneMinute, and TimeDateWZControl and their control of the automatic conversion of Daylight Saving Time to standard time and back.

See Teradata Vantage™ - Database Utilities, B035-1102 for information about the tdlocaledef utility and how it is used to specify rules for time zone strings.