Implicit TIMESTAMP-to-DATE Conversion - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

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

Teradata Database performs implicit conversion from TIMESTAMP types to DATE in some cases. See Implicit Conversion of DateTime Types.

The following conversions are supported:

From source type... To target type...
TIMESTAMP DATE

ANSIDate dateform mode or IntegerDate dateform mode

TIMESTAMP WITH TIME ZONE

The TIMESTAMP value is always converted to DATE in case of comparison.