Bosses, strives for the time difference, specify certain period of time the total time, become a fig-CodePudding

The original SQL

 
Select 
Poa poano, 
Wftask starttime, 
Wftask endtime, 
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, 
Usr. Realname wftaskExcutor, 
Usr2. Realname wftaskPrevExcutor 
The 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

CodePudding user response:

Bosses, repeat the taskname corresponding time, because the executor, only take 1 time to calculate,