The format in which TIME values are retrieved as strings by applications is controlled by the time_format option setting.
For example, the TIME value 23:59:59.999999 can be returned to an application as 23:59:59, 23:59:59.999, or as 23:59:59.999999 depending on the time_format option setting.
A TIME value requires 8 bytes of storage.
When using ODBC, a TIME value sent or retrieved as a binary value (using an ODBC TIME_STRUCT structure) is restricted to an
accuracy of hours, minutes, and seconds. Fractional seconds are not part of the structure. For this reason, TIME values should
be sent or retrieved as strings if increased accuracy is desired.
The TIME data type is supported by Adaptive Server Enterprise. However, Adaptive Server Enterprise supports millisecond
resolution (three digits) rather than microsecond resolution (six digits). You should be aware of these differences when migrating
data between SQL Anywhere and Adaptive Server Enterprise. To migrate TIME values, use the Adaptive Server Enterprise BIGTIME