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

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
Teradata requests that customers open an incident so that the Customer Support Center 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 .