17.10 - Format Consistency - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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'.