时间间隔（1h2m3s）

# 时间间隔（1h2m3s）

```SQL
--NUMTODSINTERVAL
--numtoyminterval
--extract

SELECT t.table_name,t.job_start_time,t.job_end_time,
       extract(HOUR FROM to_timestamp(job_end_time,'yyyy-mm-dd hh24:mi:ss')-to_timestamp(job_start_time,'yyyy-mm-dd hh24:mi:ss')) || ':' ||
       extract(MINUTE FROM to_timestamp(job_end_time,'yyyy-mm-dd hh24:mi:ss')-to_timestamp(job_start_time,'yyyy-mm-dd hh24:mi:ss')) || ':' ||
       extract(SECOND FROM to_timestamp(job_end_time,'yyyy-mm-dd hh24:mi:ss')-to_timestamp(job_start_time,'yyyy-mm-dd hh24:mi:ss')) job_time,
       extract(HOUR FROM NUMTODSINTERVAL(to_date(job_end_time,'yyyy-mm-dd hh24:mi:ss') - to_date(job_start_time,'yyyy-mm-dd hh24:mi:ss'),'day')) || ':' ||
       extract(MINUTE FROM NUMTODSINTERVAL(to_date(job_end_time,'yyyy-mm-dd hh24:mi:ss') - to_date(job_start_time,'yyyy-mm-dd hh24:mi:ss'),'day')) || ':' ||
       extract(SECOND FROM NUMTODSINTERVAL(to_date(job_end_time,'yyyy-mm-dd hh24:mi:ss') - to_date(job_start_time,'yyyy-mm-dd hh24:mi:ss'),'day')) job_time1
FROM table_name t
WHERE job_end_time BETWEEN to_char(SYSDATE-30,'yyyy.mm.dd hh24:mi:ss') AND to_char(SYSDATE,'yyyy.mm.dd hh24:mi:ss')
AND table_name = 'XXX'
ORDER BY job_end_time DESC
```