Oracle中计算两个时间段的时分秒天周数语句

SELECT TO_CHAR(cedate,'MMDDYYYY:HH24:MI:SS') cedate,

TO_CHAR(cbakdt,'MMDDYYYY:HH24:MI:SS') cbakdt,

trunc(86400*(cbakdt-cedate))-60*(trunc((86400*(cbakdt-cedate))/60)) seconds,

trunc((86400*(cbakdt-cedate))/60)-60*(trunc(((86400*(cbakdt-cedate))/60)/60)) minutes,

trunc(((86400*(cbakdt-cedate))/60)/60)-24*(trunc((((86400*(cbakdt-cedate))/60)/60)/24)) hours,

trunc((((86400*(cbakdt-cedate))/60)/60)/24) days,

trunc(((((86400*(cbakdt-cedate))/60)/60)/24)/7) weeks

FROM cl_vflow;