17,086
社区成员
发帖
与我相关
我的任务
分享
--如果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