Contents Index TIMESTAMP_FORMAT option [compatibility] TRUNCATE_TIMESTAMP_VALUES option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

TRUNCATE_DATE_VALUES option [database]


Function 

To change the storage of time values within DATE data type values.

Allowed values 

ON, OFF

Default 

ON for databases created with Version 7 or later software, or upgraded to Version 7 or later.

OFF for older databases

See also 

DATE_FORMAT option [compatibility]

DATE data type [Date and Time]

Description 

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.


Contents Index TIMESTAMP_FORMAT option [compatibility] TRUNCATE_TIMESTAMP_VALUES option [database]