The range of values for INTERVAL SECOND is as follows.
| Type, Precision, and Fractional Seconds Precision | Minimum Value | Maximum Value |
|---|---|---|
| INTERVAL SECOND(1,0) | -'9' | '9' |
| INTERVAL SECOND(1,1) | -'9.9' | '9.9' |
| INTERVAL SECOND(1,2) | -'9.99' | '9.99' |
| INTERVAL SECOND(1,3) | -'9.999' | '9.999' |
| INTERVAL SECOND(1,4) | -'9.9999' | '9.9999' |
| INTERVAL SECOND(1,5) | -'9.99999' | '9.99999' |
| INTERVAL SECOND(1,6) | -'9.999999' | '9.999999' |
| INTERVAL SECOND(2,0) | -'99' | '99' |
| INTERVAL SECOND(2,1) | -'99.9' | '99.9' |
| INTERVAL SECOND(2,2) | -'99.99' | '99.99' |
| INTERVAL SECOND(2,3) | -'99.999' | '99.999' |
| INTERVAL SECOND(2,4) | -'99.9999' | '99.9999' |
| INTERVAL SECOND(2,5) | -'99.99999' | '99.99999' |
| INTERVAL SECOND(2,6) | -'99.999999' | '99.999999' |
| INTERVAL SECOND(3,0) | -'999' | '999' |
| INTERVAL SECOND(3,1) | -'999.9' | '999.9' |
| INTERVAL SECOND(3,2) | -'999.99' | '999.99' |
| INTERVAL SECOND(3,3) | -'999.999' | '999.999' |
| INTERVAL SECOND(3,4) | -'999.9999' | '999.9999' |
| INTERVAL SECOND(3,5) | -'999.99999' | '999.99999' |
| INTERVAL SECOND(3,6) | -'999.999999' | '999.999999' |
| INTERVAL SECOND(4,0) | -'9999' | '9999' |
| INTERVAL SECOND(4,1) | -'9999.9' | '9999.9' |
| INTERVAL SECOND(4,2) | -'9999.99' | '9999.99' |
| INTERVAL SECOND(4,3) | -'9999.999' | '9999.999' |
| INTERVAL SECOND(4,4) | -'9999.9999' | '9999.9999' |
| INTERVAL SECOND(4,5) | -'9999.99999' | '9999.99999' |
| INTERVAL SECOND(4,6) | -'9999.999999' | '9999.999999' |