Date Data Types


The date data types that are supported are listed in Table: OLAP DML Date Data Types.

OLAP DML Date Data Types

Data Type Data Value
DATETIME Dates between January 1, 4712 B.C. and December 31, 9999 A.D., and times in hours, minutes and seconds.
DATE Dates between January 1, 1000 A.D. and December 31, 9999 A.D.

A number of options determine how date and time values are handled. These options are listed in Table: Date and Time Options.