Since a TIMESTAMP value is precise to six decimal places in SQL 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 SQL Anywhere stores to
For MobiLink synchronization, if you are going to set this option, it must be set before performing the first synchronization.