SQL> select systimestamp-365 from dual;SYSTIMESTAMP-365 ------------------- 2010-06-02 13:58:33
--如果2012-01-01是世界末日,那么我们距离那天好友多少秒: select day*24*60*60+hour*60*60+minute*60+second second from (select extract(day from edt-sdt) day, extract(hour from edt-sdt) hour, extract(minute from edt-sdt) minute, extract(second from edt-sdt) second from (select to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss.ff') sdt, to_timestamp('2012-01-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff') edt from dual)) / SECOND ---------- 18352374
SQL> select systimestamp-365 from dual;SYSTIMESTAMP-365
-------------------
2010-06-02 13:58:33
--如果2012-01-01是世界末日,那么我们距离那天好友多少秒:
select day*24*60*60+hour*60*60+minute*60+second second
from (select extract(day from edt-sdt) day,
extract(hour from edt-sdt) hour,
extract(minute from edt-sdt) minute,
extract(second from edt-sdt) second
from (select to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss.ff') sdt,
to_timestamp('2012-01-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff') edt
from dual))
/
SECOND
----------
18352374