Analytics 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.