These index types are supported by date and time data.
All date and time data types support the CMP, HG, HNG, and LF index types; the WD index type is not supported.
DATE data supports the DATE index.
TIME data supports the TIME index.
DATETIME and TIMESTAMP data support the DTTM index.