16.10 - Changing the Default Formats - 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

You can change the default formats that Teradata SQL uses for the following data types:

  • BIGINT
  • BYTEINT
  • DATE
  • DECIMAL/NUMERIC
  • FLOAT/REAL/DOUBLE PRECISION
  • INTEGER
  • NUMBER
  • SMALLINT
  • TIME and TIME WITH TIME ZONE
  • TIMESTAMP and TIMESTAMP WITH TIME ZONE

To change the data type default formats, you must create a specification for data formatting (SDF) file, and then use the tdlocaledef utility. For details, see Utilities.

Teradata Database uses the changes when it assigns formats to columns of new tables where the CREATE TABLE statement does not explicitly specify the column format. Columns of tables that were created prior to changing the default formats continue to use the format that Teradata Database assigned to the column at the time the table was created.

To view the settings of the preceding data type default formats for the current session, use the HELP SESSION statement. For more information, see “HELP” and “SHOW” in SQL Data Definition Language.