16.10 - Relationship to SDF - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

In addition to defining the default display formats for numeric, date, time, and timestamp data types, the Specification for Data Formatting (SDF) file defines strings that Teradata Database displays in place of certain formatting characters that appear in a FORMAT phrase.

For example, you can set the value of the Currency string in the SDF file to the currency symbol native to your locale. To include that currency symbol when you display numeric monetary information in an SQL SELECT statement, use the L formatting character in the FORMAT phrase.

For details on how to create an SDF file and convert the contents into an internal form usable by Teradata Database, see the description of the tdlocaledef utility in the Utilities book.