Format Consistency

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

If a field is declared as type DATE and a FORMAT phrase is specified for it, the date must be entered in the specified format and it must be enclosed in apostrophes.

For example, data supplied to, or used in, a conditional WHERE or HAVING clause for the following column must be defined as 'OCT 24, 1985'.

DOB DATE FORMAT 'MMMbDD,bYYYY'

This format consistency restriction applies only to the date values themselves, and not to the date separators. The input date separators need not match the FORMAT phrase date separators. In addition, you can enter a 4-digit year even if the FORMAT phrase specifies the year as 'YY'.