ORACLE 计算时间相减间隔

1.计算天数

select sysdate- to_date('2009-07-14 12:00:0' ,'yyyy-mm-dd hh24:mi:ss') from dual;

2.计算小时数

select (sysdate- to_date('2009-07-14 12:00:00','yyyy-mm-dd hh24:mi:ss'))*24 from dual;

3.计算分钟数

select (sysdate- to_date('2009-07-14 12:00:00','yyyy-mm-dd hh24:mi:ss'))*24 *60 from dual;

4.计算秒数

select (sysdate- to_date('2009-07-14 12:00:00','yyyy-mm-dd hh24:mi:ss'))*24 *60*60    from dual;

例：

 select
     trunc(((sysdate- to_date('2014-05-30 10:22:01','yyyy-mm-dd hh24:mi:ss'))*24*60*60))  as time
 from  dual

 select
         trunc(((to_date('2014-05-30 10:56:01','yyyy.mm.dd hh24.mi.ss')- to_date('2014-05-30 10:56:00','yyyy.mm.dd hh24.mi.ss'))*24*60*60))  as time
        from  dual

select (sysdate-to_date('2014-05-30 11:00:00','yyyy-mm-dd hh24:mi:ss'))*24*60*60 from dual;