Implicit Conversion of DateTime Types

In comparisons involving DateTime operands that differ, Vantage performs an implicit conversion according to the following table.

Expression Operand	Other Expression Operand	How Vantage Compares Data
TIMESTAMP	DATE ANSIDate dateform mode or IntegerDate dateform mode	As DATE data. See Implicit TIMESTAMP-to-DATE Conversion.
TIMESTAMP WITH TIME ZONE	DATE ANSIDate dateform mode or IntegerDate dateform mode	As DATE data. See Implicit TIMESTAMP-to-DATE Conversion.
Interval The INTERVAL type must have only one field, for example, INTERVAL YEAR.	Exact Numeric	As numeric data. See Implicit INTERVAL-to-Numeric Conversion.

Implicit Conversion of DateTime Types - Teradata Vantage