SQL Engine 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.