Identifies a field as an INTERVAL value defining a period of time in years.
ANSI Compliance
INTERVAL YEAR is ANSI SQL:2011 compliant.
Syntax
INTERVAL YEAR [ ( precision ) ] [ attributes [...] ]
Syntax Elements
- precision
- The permitted range of digits for YEAR, ranging from 1 to 4.
- attributes
- Appropriate data type, column storage, or column constraint attributes.