Identifies a field as an INTERVAL value defining a period of time in seconds.
ANSI Compliance
INTERVAL SECOND is ANSI SQL:2011 compliant.
Syntax
INTERVAL SECOND [ ( precision [, fractional_seconds_precision ] ) ] [ attributes [...] ]
Syntax Elements
- precision
- The permitted range of digits for SECOND, 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.