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