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

Syntax

TIME

Remarks

The fraction is stored to 6 decimal places. A TIME value requires 8 bytes of storage. (ODBC standards restrict TIME data type to an accuracy of seconds. For this reason you should not use TIME data types in WHERE clause comparisons that rely on a higher accuracy than seconds.)

See also

• TIMESTAMP data type
• Date and time functions

Standards and compatibility