Implicit DATE-to-TIMESTAMP 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 DATE to TIMESTAMP types in some cases. See Implicit Conversion of DateTime Types.

The following conversions are supported:

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

ANSI Date dateform mode or IntegerDate dateform mode

TIMESTAMP

TIMESTAMP WITH TIME ZONE

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