![]() Previous |
![]() Next |
The Oracle OLAP DML DATE data type does not correspond to the SQL data type of the same name. It is, instead, is an older data type that is unique to the OLAP DML. The OLAP DML DATE
data type is a valid data type for variables and for dimensions of type DAY, WEEK, MONTH, QUARTER, and YEAR as discussed in the DEFINE DIMENSION (DWMQY) command topic. It is used to store day, month, and year data (but not hour and minute data) between January 1, 1000 A.D. and December 31, 9999 A.D. Because the OLAP DML DATE
data type does not include hour and minute data, it is often referred to as the DATE-only data type.
Tip: The Oracle OLAP DML data type that corresponds to the SQL DATE data type is namedDATETIME . See DATETIME Data Type for more information. |