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;