17.10 - Implicit Conversion of DateTime Types - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

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

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

IF one expression operand is … AND the other expression operand is … THEN Vantage 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 .