In comparisons involving DateTime operands that differ, Teradata Database performs an implicit conversion according to the following table.
| IF one expression operand is … | AND the other expression operand is … | THEN Teradata Database compares the data as … |
|---|---|---|
| TIMESTAMP | DATE ANSIDate dateform mode or IntegerDate dateform mode |
DATE. See "Implicit TIMESTAMP-to-DATE Conversion" in Teradata Vantage™ Data Types and Literals, B035-1143 . |
| TIMESTAMP WITH TIME ZONE | ||
| Interval The INTERVAL type must have only one field, e.g. INTERVAL YEAR. |
Exact Numeric | Numeric. See "Implicit INTERVAL-to-NUMERIC Conversion" in Teradata Vantage™ Data Types and Literals, B035-1143 . |