While all three products support some form of date and time data, there are some differences.
Adaptive Server Anywhere and IQ support the 4-byte date and time data types
Adaptive Server Enterprise supports an 8-byte datetime type, and timestamp as a user-defined data type (domain) implemented as binary (8).
Adaptive Server Anywhere and IQ support an 8-byte timestamp type, and an 8-byte datetime domain implemented as timestamp. The millisecond precision of the Anywhere/IQ datetime data type differs from that of Adaptive Server Enterprise.
With the option AUTOMATIC_TIMESTAMP set on, Anywhere has the same behavior as Adaptive Server Enterprise in giving columns whose data type is timestamp an automatic default of timestamp if no other default is provided.
Display formats for dates have different defaults:
Adaptive Server Enterprise defaults to displaying dates ‘MMM-DD-YYYY’ but can be changed by setting an option.
Adaptive Server Anywhere and IQ default to the ISO ‘YYYY-MM-DD’ format but can be changed by setting an option.
Time conversions are as follows:
Adaptive Server Enterprise varies how it converts time stored in a string to an internal time depending on whether the fraction part of the second was delimited by a colon or a period.
Adaptive Server Anywhere and IQ convert them in the same manner irrespective of the delimiter.
When you insert a time into a datetime column:
Adaptive Server Enterprise and IQ default to supplying 1st January 1900.
Adaptive Server Anywhere defaults to supplying the current date.
