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/07/19 02:21:36
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
x)+I-*KQȄ1ԍ rJ2lޜg3ֿ3KT@ADH]25H$#VFVzF&f `ũy)(z6F &Hd0Xwj%h6Pv6C2؟OdW_3^[cdǮgs:Mx ::^dG@ytnbKv=1hP Pɮ6?!6YdWϓ<]2hK t@;:4

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(时间间隔)