ASA Database Administration Guide
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
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.
TRUNCATE_TIMESTAMP_VALUES option [database]
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.