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