ASA Database Administration Guide
Database Options
Alphabetical list of options
To change the storage of time values within DATE data type values.
ON, OFF
ON for databases created with Version 7 or later software, or upgraded to Version 7 or later.
OFF for older databases
DATE_FORMAT option [compatibility]
DATE data type [Date and Time]
When the option is set to ON, columns or variables declared as DATE data types have no hours and minutes stored.
When the option is set to OFF, DATE columns or variables have hours and minutes stored also. These time components are typically not displayed because of the DATE_FORMAT setting. However, exact comparisons between DATE values may unexpectedly fail because of non-matching time components.