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