15.00 - Specifying a Default Time Zone for a User - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Specifying a Default Time Zone for a User

When you assign a default time zone to a user, each time that user logs onto Teradata Database, 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, Teradata Database 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 zones are designed to be used for locations or time zones that do not follow Daylight Saving Time.

The following table documents the time zone options and their definitions.

 

Option

Definition

LOCAL

The value for the local time zone displacement defined as the system default for this user.

Note that this is a persistent setting. If the system-defined default time zone should change, the value defined for the user remains at the value defined for it when she was created.

To change the value, you must submit a MODIFY USER request (see “MODIFY USER” on page 831).

NULL

No default time zone displacement is defined for the user.

± ‘quotestring’

An optionally signed text string that sets a non‑system-default interval offset for converting the user default time zone displacement.

The format is hh:mm.

‘time_zone_string’

Sets the value of the default time zone for the user to the displacement specified by ‘time_zone_string’.

If you specify an explicit non‑GMT time zone string, it is passed to a system‑defined UDF named GetTimeZoneDisplacement that interprets the string and determines the appropriate time zone displacement for the session (see SQL Functions, Operators, Expressions, and Predicates for information about the GetTimeZoneDisplacement UDF).

Time zone strings that are expressed in terms of GMT do not enable automatic adjustments for Daylight Savings Time. Regions that do not follow Daylight Savings Time are only represented by GMT values.

The following table documents the time zone strings supported by Teradata Database.

 

                                                                        Time Zone Strings

  • Africa Egypt
  • Africa Morocco
  • Africa Namibia
  • America Alaska
  • America Aleutian
  • America Argentina
  • America Atlantic
  • America Brazil
  • America Central
  • America Chile
  • America Cuba
  • America Eastern
  • America Mountain
  • America Newfoundland
  • America Pacific
  • America Paraguay
  • America Uruguay
  • Argentina
  • Asia Gaza
  • Asia Iran
  • Asia Iraq
  • Asia Irkutsk
  • Asia Israel
  • Asia Jordan
  • Asia Kamchatka
  • Asia Krasnoyarsk
  • Asia Lebanon
  • Asia Magadan
  • Asia Omsk
  • Asia Syria
  • Asia Vladivostok
  • Asia West Bank
  • Asia Yakutsk
  • Asia Yekaterinburg
  • Australia Central
  • Australia Eastern
  • Australia Western
  • Europe Central
  • Europe Eastern
  • Europe Kaliningrad
  • Europe Moscow
  • Europe Samara
  • Europe Western
  • Indian Mauritius
  • Mexico Central
  • Mexico Northwest
  • Mexico Pacific
  • Pacific New Zealand
  • Pacific Samoa
  • GMT-11
  • GMT-10
  • GMT-9
  • GMT-8
  • GMT-7
  • GMT-6:30
  • GMT-6
  • GMT-5
  • GMT-4
  • GMT-3
  • GMT-2
  • GMT-1
  • GMT
  • GMT+1
  • GMT+2
  • GMT+3
  • GMT+3:30
  • GMT+4
  • GMT+4:30
  • GMT+5
  • GMT+5:30
  • GMT+5:45
  • GMT+6
  • GMT+6:30
  • GMT+7
  • GMT+8
  • GMT+8:45
  • GMT+9
  • GMT+9:30
  • GMT+10
  • GMT+11
  • GMT+11:30
  • GMT+12
  • GMT+13
  • GMT+14
  • See SQL Functions, Operators, Expressions, and Predicates for the definition of the GetTimeZoneDisplacement UDF that converts time zone values when Daylight Saving Time changes.

    See Utilities: Volume 1 (A-K) 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 Utilities: Volume 2 (L-Z) for information about the tdlocaledef utility and how it is used to specify rules for time zone strings.

    Related Topics

    See “Activating Permanent Journaling” on page 43 for information about activating permanent journaling for existing tables.

    Also see the following SQL statements:

  • “ALTER TABLE (Basic Table Parameters)” on page 31
  • “ALTER TABLE” in SQL Data Definition Language Syntax and Examples
  • “CREATE DATABASE” on page 225
  • “CREATE DATABASE” in SQL Data Definition Language Syntax and Examples
  • “MODIFY DATABASE” on page 827
  • “MODIFY DATABASE” in SQL Data Definition Language Syntax and Examples
  • “MODIFY USER” on page 831
  • “MODIFY USER” in SQL Data Definition Language Syntax and Examples
  • “SET TIME ZONE” on page 887
  • “SET TIME ZONE” in SQL Data Definition Language Syntax and Examples
  • See International Character Set Support for information about how to create a custom export width table.