DATE and DTTM index types process queries involving date or datetime quantities.
A DATE index is used on columns of data type DATE to process certain queries involving date quantities.
The DTTM index is used on columns of data type DATETIME or TIMESTAMP to process certain queries involving datetime quantities.