The range of values for INTERVAL MINUTE TO SECOND is as follows.
Type, Precision, and Fractional Seconds Precision | Minimum Value | Maximum Value |
---|---|---|
INTERVAL MINUTE(1) TO SECOND(0) | -'9:59' | '9:59' |
INTERVAL MINUTE(1) TO SECOND(1) | -'9:59.9' | '9:59.9' |
INTERVAL MINUTE(1) TO SECOND(2) | -'9:59.99' | '9:59.99' |
INTERVAL MINUTE(1) TO SECOND(3) | -'9:59.999' | '9:59.999' |
INTERVAL MINUTE(1) TO SECOND(4) | -'9:59.9999' | '9:59.9999' |
INTERVAL MINUTE(1) TO SECOND(5) | -'9:59.99999' | '9:59.99999' |
INTERVAL MINUTE(1) TO SECOND(6) | -'9:59.999999' | '9:59.999999' |
INTERVAL MINUTE(2) TO SECOND(0) | -'99:59' | '99:59' |
INTERVAL MINUTE(2) TO SECOND(1) | -'99:59.9' | '99:59.9' |
INTERVAL MINUTE(2) TO SECOND(2) | -'99:59.99' | '99:59.99' |
INTERVAL MINUTE(2) TO SECOND(3) | -'99:59.999' | '99:59.999' |
INTERVAL MINUTE(2) TO SECOND(4) | -'99:59.9999' | '99:59.9999' |
INTERVAL MINUTE(2) TO SECOND(5) | -'99:59.99999' | '99:59.99999' |
INTERVAL MINUTE(2) TO SECOND(6) | -'99:59.999999' | '99:59.999999' |
INTERVAL MINUTE(3) TO SECOND(0) | -'999:59' | '999:59' |
INTERVAL MINUTE(3) TO SECOND(1) | -'999:59.9' | '999:59.9' |
INTERVAL MINUTE(3) TO SECOND(2) | -'999:59.99' | '999:59.99' |
INTERVAL MINUTE(3) TO SECOND(3) | -'999:59.999' | '999:59.999' |
INTERVAL MINUTE(3) TO SECOND(4) | -'999:59.9999' | '999:59.9999' |
INTERVAL MINUTE(3) TO SECOND(5) | -'999:59.99999' | '999:59.99999' |
INTERVAL MINUTE(3) TO SECOND(6) | -'999:59.999999' | '999:59.999999' |
INTERVAL MINUTE(4) TO SECOND(0) | -'9999:59' | '9999:59' |
INTERVAL MINUTE(4) TO SECOND(1) | -'9999:59.9' | '9999:59.9' |
INTERVAL MINUTE(4) TO SECOND(2) | -'9999:59.99' | '9999:59.99' |
INTERVAL MINUTE(4) TO SECOND(3) | -'9999:59.999' | '9999:59.999' |
INTERVAL MINUTE(4) TO SECOND(4) | -'9999:59.9999' | '9999:59.9999' |
INTERVAL MINUTE(4) TO SECOND(5) | -'9999:59.99999' | '9999:59.99999' |
INTERVAL MINUTE(4) TO SECOND(6) | -'9999:59.999999' | '9999:59.999999' |