Identifies a field as an INTERVAL value defining a period of time in hours, minutes, and seconds.
ANSI Compliance
INTERVAL HOUR TO SECOND is ANSI SQL:2011 compliant.
Syntax
INTERVAL HOUR [ ( precision ) ] TO SECOND [ ( fractional_seconds_precision ) ] [ attributes [...] ]
Syntax Elements
- precision
- The permitted range of digits for HOUR, ranging from one to four.
- fractional_seconds_precision
- The fractional precision for the values of SECOND, ranging from zero to six.
- attributes
- Appropriate data type, column storage, or column constraint attributes.