两个时间相差多少秒用哪个函数？

Question

SQL> select sysdate-to_date('2003-03-13 17:34:45','yyyy-mm-dd hh24:mi:ss') from dual;SYSDATE-TO_DATE('2003-03-1317:34:45','YYYY-MM-DDHH24:MI:SS')
------------------------------------------------------------
                                                  -.00322917

Answer 1

同上,因为Oracle的日期是以天为基本单位.

Answer 2

SQL> select (sysdate-to_date('2003-03-13 16:34:45','yyyy-mm-dd hh24:mi:ss'))*24*3600 from dual;(SYSDATE-TO_DATE('2003-03-1316:34:45','YYYY-MM-DDHH24:MI:SS'))*24*3600
----------------------------------------------------------------------
                                                                  3474

Answer 3

SQL> select abs(sysdate-to_date('2003-1-1','yyyy-mm-dd'))*24*60*60 from dual;(SYSDATE-TO_DATE('2003-1-1','Y
------------------------------
                       6199764

Answer 4

select to_char(sysdate,'sssss') from dual;