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.