16.10 - Changing Time Zones, Currencies, and Formats for Date, Time, and Numbers - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

To define or change your time zone or how Teradata Database 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 Teradata Database 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 Teradata Database 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 Utilities.