请问怎样计算两个日期之间相差多少天啊？有函数吗？感恩！！

Question

SQL> select to_date('2002-01-01','yyyy-mm-dd')-to_date('2002-01-12','yyyy-mm-dd') from dual;TO_DATE('2002-01-01','YYYY-MM-DD')-TO_DATE('2002-01-12','YYYY-MM-DD')
-----------------------------------------
                                   -11
带绝对值：
SQL> select abs(to_date('2002-01-01','yyyy-mm-dd')-to_date('2002-01-12','yyyy-mm-dd')) from dual;ABS(TO_DATE('2002-01-01','YYYY-MM-DD')-TO_DATE('2002-01-12','YYYY-MM-DD'))
--------------------------------------------------------------------------
                                                                        11

Answer 1

日期之间相减会得到它们的相距天数.