麻煩在于 有倆個取1條，另一條需要時間總求和，求大佬看看怎么寫？用分鐘表示總時長，即可，前面分割了天/時/分，應該不好做，后面有個分鐘統計， 用它就行。原sql
select -- wftask.*,
usr.realname wftaskExcutor,
usr2.realname wftaskPrevExcutor,
wftask.taskname,
extract(day from wftask.endtime - wftask.starttime) wftaskDay,
extract(hour from wftask.endtime - wftask.starttime) wftaskHour,
extract(minute from wftask.endtime - wftask.starttime) wftaskMin,
round(to_number(to_date(to_char(wftask.endtime,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')
-to_date(to_char(wftask.starttime,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss'))*24*60) wftaskSumMin
from co_workflow_task wftask
inner join co_user usr
on wftask.Executor = usr.username
inner join co_user usr2
on wftask.Prevexecutor = usr2.username
inner join tb_sm_poa_info poa
on poa.id = wftask.Extendfield1
where poa.id='402897bb777bc6f101777bd2ab210017'
order by wftask.starttime desc
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/266462.html
標籤：開發
下一篇：問各位大佬一個問題，請幫忙解答下