Implicit Conversion of DateTime Types

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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 .