Changing Time Zone Strings and Rules - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™
Teradata requests that customers open an incident so that Teradata Services can assist you in changing time zone settings on your system.

If you do not need Daylight Saving Time, you can set the time using the DBS Control utility settings SystemTimeZoneHour and SystemTimeZoneMinute.

To redefine your time zone, check the list of available time zone strings and their rules in /usr/tdbms/etc/tdlocaledef_tzrules.txt. These rules are also in the GetTimeZoneDisplacement UDF. To change a time zone string and rules, you must change both the GetTimeZoneDisplacement UDF and tdlocaledef.

For more information, see “Adding or Modifying Time Zone Strings” under the topic “GetTimeZoneDisplacement” in Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211 and DBS Control utility and Teradata Locale Definition utility in Teradata Vantage™ - Database Utilities, B035-1102.