Identifies a field as a TIME value.
This is not the value returned by the TIME function, which is formatted as a REAL number.
ANSI Compliance
TIME is non-ANSI standard. SQL Engine stores a TIME value in UTC.
Syntax
TIME [ ( fractional_seconds_precision ) ] [ attributes [...] ]
Syntax Elements
- fractional_seconds_precision
- A single digit representing the number of significant digits in the fractional portion of the SECOND field.
- attributes
- Appropriate data type, column storage, or column constraint attributes.