ASA SQL Reference
  SQL Data Types
    Date and time data types

TIME data type [Date and Time]

Function 

The time of day, containing hour, minute, second and fraction of a second.

Syntax 

TIME

Usage 

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.)

Standards and compatibility 

• SQL/92    Vendor extension.

• Sybase    Supported by Adaptive Server Enterprise 12.5.1 and later.

See also 

TIMESTAMP data type [Date and Time]