total_expire_minute = 40004280
selectt.total_expire_minute,
cast(t.total_expire_minute / 86400 as signed integer) day,
cast(t.total_expire_minute % 86400 / 3600 as signed integer) hour,
cast(t.total_expire_minute % 86400 % 3600 / 60 as signed integer) minute,
cast(t.total_expire_minute % 86400 % 3600 % 60 as signed integer) second
from
(select
e.user_id,
u.real_name,
count(t.id) expire_task_num,
sum(
cast(
(e.end_time - t.expired_time) / 1000 as signed integer
)
) total_expire_minute
from
wf_ins_task_execute e,
wf_ins_task t,
sys_user u
where e.wf_ins_task_id = t.id
and e.user_id = u.id
and u.status = 1
and t.effective_time > 0
and e.end_time > t.expired_time
and e.end_time is not null
group by e.user_id,
u.real_name
order by expire_task_num desc) t