- ANSI DATE literal format
- Format of the DATE value
- DATE format determined by DateForm and default DATE data type format in the SDF. See DATE Formats.
For example, the comparison works if the data is CHAR(8) in the form YY/MM/DD and a DATE column format is YY/MM/DD. The comparison fails, however, if the column format is YYYY-MM-DD.
To perform comparisons that do not meet these qualifications, convert the values as described in Teradata Vantage™ SQL Functions, Expressions, and Predicates, B035-1145.