16.20 - Result Type and Attributes - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

prodname
Advanced SQL Engine
Teradata Database
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1145-162K

The default format of DATE depends on the value of the Dateform mode. The data type, format, and title for DATE are as follows:

Data Type Format Title
Dateform Mode DATE Function Format
DATE INTEGERDATE the default format for DATE data types as specified in the SDF. Date
ANSIDATE 'YYYY-MM-DD'