最初由 duanzilin 发布
[B]这样不知道满不满足你的要求:
SQL> select (to_date('20050831130100','yyyymmddhh24miss') - to_date('20050830120000','yyyymmddhh24miss')) day to second from dual;
(TO_DATE('20050831130100','YYY
---------------------------------------
+000000001 01:01:00 [/B]
改造一下
select substr((to_date(20050830130000,'YYYYMMDDHH24MISS')- to_date(20050830120000,'YYYYMMDDHH24MISS')) day to second,-8) s from dual; |