本文共 1432 字，大约阅读时间需要 4 分钟。

Oracle ??????????????????????????????????????? SQL ????????????????????????

1. ??????

SELECT months_between('19-12-1999', '19-3-1999') AS mon_between FROM dual;

???9

????????????????????????9???

2. ????????

SELECT months_between(to_date('2000.05.20', 'yyyy.mm.dd'), to_date('2005.05.20', 'yyyy.mm.dd')) AS mon_betw FROM dual;

???-60

??????????2000?5?20??2005?5?20??????????-60???

3. ????????

SELECT ceil((to_date('2008-05-02 00:00:00', 'yyyy-mm-dd hh24-mi-ss') - to_date('2008-04-30 23:59:59', 'yyyy-mm-dd hh24-mi-ss')) * 24 * 60 * 60 * 1000) AS seconds FROM dual;

???86401000

??????????2008?4?30?23:59:59?2008?5?2?00:00:00?????????????????86401000??

4. ?????????

SELECT ceil((to_date('2008-05-02 00:00:00', 'yyyy-mm-dd hh24-mi-ss') - to_date('2008-04-30 23:59:59', 'yyyy-mm-dd hh24-mi-ss')) * 24 * 60) AS minutes FROM dual;

???86401

??????????2008?4?30?23:59:59?2008?5?2?00:00:00??????????????????86401???

5. ?????????

SELECT ceil((to_date('2008-05-02 00:00:00', 'yyyy-mm-dd hh24-mi-ss') - to_date('2008-04-30 23:59:59', 'yyyy-mm-dd hh24-mi-ss')) * 24) AS hours FROM dual;

???25

??????????2008?4?30?23:59:59?2008?5?2?00:00:00??????????????????25???

6. ????????

SELECT ceil((to_date('2008-05-02 00:00:00', 'yyyy-mm-dd hh24-mi-ss') - to_date('2008-04-30 23:59:59', 'yyyy-mm-dd hh24-mi-ss'))) AS days FROM dual;

???2

??????????2008?4?30?23:59:59?2008?5?2?00:00:00?????????2??

?????????? Oracle ????????????????????????????????????????