Result Type and Attributes

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
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'