TIME data type

The TIME data type is used to store the time of day, containing the hour, minute, second, and fraction of a second.

Syntax

TIME

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.

Standards and compatibility

SQL/2008 Compatible with SQL/2008.
Transact-SQL 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 data type.

Discuss this page in DocCommentXchange.

TIME data type

Syntax

Remarks

See also

Standards and compatibility