Changing Time Zones and More | Teradata Vantage - Changing Time Zones, Currencies, and Formats for Date, Time, and Numbers - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

To define or change your time zone or how Vantage formats numeric, date, time, and currency output, use the command-line utility Teradata Locale Definition (tdlocaledef).

Tdlocaledef converts a specification for data formatting (SDF) text file into a Vantage globally distributed object (GDO), an internal binary format file that stores configuration information. The GDO is made available simultaneously to all nodes of an MPP system. The utility can also convert the text file to a local, non-distributed, binary file, that can be converted back to text in order to ensure the formatting syntax is valid.

  • Format changes take effect only after Vantage is restarted, and do not affect columns that were created prior to the restart.
  • A new Teradata system is typically staged with global defaults in the SDF file that are appropriate for the United States. International customers and those who need customized settings, including TimeZoneString, can change the defaults using tdlocaledef.

For more details on the SDF file, see “SDF File” in the description of the Teradata Locale Definition (tdlocaledef) utility in Teradata Vantage™ - Database Utilities, B035-1102.