The range of values for INTERVAL YEAR is as follows.
| Type and Precision | Minimum Value | Maximum Value |
|---|---|---|
| INTERVAL YEAR(1) | -'9' | '9' |
| INTERVAL YEAR(2) | -'99' | '99' |
| INTERVAL YEAR(3) | -'999' | '999' |
| INTERVAL YEAR(4) | -'9999' | '9999' |
Decimal values are not allowed for Interval data types except for second intervals.