Data Type Default Formats

Teradata Vantage™ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Teradata SQL uses a set of default formats for displaying expressions and column data, and for conversions between data types.

For example, Teradata Database assigns a format to every column of a table at the time the table is created. If the CREATE TABLE statement omits the format for a column, then Teradata Database assigns a default format for the data type of the column.

You can override the default format by using the FORMAT phrase in conjunction with a CREATE TABLE, ALTER TABLE, SELECT, UPDATE, DELETE, MERGE, or INSERT statement. For details, see FORMAT.

You can change the default formats that Teradata SQL uses to display numeric, date, and time data types. For details, see Changing the Default Formats.

You can also use the FORMAT phrase with CAST or with Teradata conversion syntax to convert data from one type to another. For details, see “Data Type Conversions” in Teradata Vantage™ SQL Functions, Expressions, and Predicates, B035-1145.