Compatibility of Datetime and Time Values from Adaptive Server Enterprise

A DATETIME or TIME value retrieved from an Adaptive Server Enterprise database using INSERT...LOCATION can have a different value due to the datetime precision of Open Client.

For example, the DATETIME value in the Adaptive Server Enterprise database is ‘2012-11-08 10:37:22.823’. When you retrieve it and store it in SAP Sybase IQ using INSERT...LOCATION, the value becomes ‘2012-11-08 10:37:22.823333’.