Compatibility of Datetime and Time Values from ASE

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 ‘2004-11-08 10:37:22.823’ as retrieved using INSERT...LOCATION is ‘2004-11-08 10:37:22.823333’.

Parent topic: Date, Time, Datetime, and Timestamp Data Types