In comparisons involving DateTime operands that differ, Vantage performs an implicit conversion according to the following table.
| Expression Operand | Other Expression Operand | How Vantage Compares Data |
|---|---|---|
| TIMESTAMP | DATE ANSIDate dateform mode or IntegerDate dateform mode |
As DATE data. |
| TIMESTAMP WITH TIME ZONE | ||
| Interval The INTERVAL type must have only one field, for example, INTERVAL YEAR. |
Exact Numeric | As numeric data. |