15.00 - TIME ZONE Option - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

TIME ZONE Option

The following table describes the TIME ZONE options in detail.

 

          Option

                                                            Description

LOCAL

Changes the value for the local time zone displacement to that defined for the system default.

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 the user was created. To change the value, you must submit a new MODIFY USER request.

NULL

No default TIME ZONE displacement is defined for the user.

± ‘quotestring’

An optionally signed value that sets a non-system-default interval offset for converting the user TIME ZONE displacement.

The format is hh:mm.

‘time_zone_string’

Changes 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 this system‑defined 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 valid time zone strings are listed in the following table.

The following table lists the valid time zone strings for the ‘time_zone_string’ option.

 

                                                                      Valid 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