mysql秒转天时分秒

total_expire_minute  = 40004280

select 
  t.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