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