Interval interval '300' month 结果是:+25-00 Interval '54-2' year to month 结果是:+54-02interval '11:12:10.1234567' hour to second结果是:+00 11:12:10.123457

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/01 21:08:17

Interval interval '300' month 结果是:+25-00 Interval '54-2' year to month 结果是:+54-02interval '11:12:10.1234567' hour to second结果是:+00 11:12:10.123457
Interval
interval '300' month 结果是:+25-00
Interval '54-2' year to month 结果是:+54-02
interval '11:12:10.1234567' hour to second结果是:+00 11:12:10.123457

Interval interval '300' month 结果是:+25-00 Interval '54-2' year to month 结果是:+54-02interval '11:12:10.1234567' hour to second结果是:+00 11:12:10.123457
由于MONTH 默认是2为有效位数,所以不能是300,就表示成YEAR TO MONTH 于是成了+25-00
第二个不够2位补0,第三个最后一位默认6位,收上来就是123457了

interval(时间间隔)