ASA Database Administration Guide
Database Options
Alphabetical list of options
Specifies the number of microseconds to add to a column of type TIMESTAMP in order to keep values in the column unique.
Integer, between 1 and 60 000 000 inclusive.
Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.
1
TRUNCATE_TIMESTAMP_VALUES option [database]
Since a TIMESTAMP value is precise to six decimal places in Adaptive Server Anywhere, by default 1 microsecond (0.000001 of a second) is added to differentiate between two identical TIMESTAMP values.
Some software, such as Microsoft Access, truncates TIMESTAMP values to three decimal places, making valid comparisons a problem. You can set the TRUNCATE_TIMESTAMP_VALUES option to ON to specify the number of decimal place values Adaptive Server Anywhere stores to maintain compatibility.