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;