Database Engine 20 may perform implicit conversion from TIMESTAMP types to DATE. See Implicit Conversion of DateTime Types.
The following conversions are supported:
| Source Type | Target Type |
|---|---|
| TIMESTAMP | DATE ANSIDate dateform mode or IntegerDate dateform mode |
| TIMESTAMP WITH TIME ZONE |
The TIMESTAMP value is converted to DATE in case of comparison.