2个字段 都转换成时间不就可以咯 纯手敲的 不知道会报错不 可能round(mi/86400,0)这3个位置 都要用to_char()转换下select yhm "用户名", round(mi/86400,0)||'/'||round(mod(mi,86400)/60,0)||'/'||mod(mi,1440) "在线时长" from ( select yhm, SUM((to_date(OUT,'hh24:mi;ss') - to_date(LOGIN,'hh24:mi;ss'))*24*60*60) mi from gyh group by yhm )
round(mi/86400,0)||'/'||round(mod(mi,86400)/60,0)||'/'||mod(mi,1440) "在线时长"
from
(
select yhm,
SUM((to_date(OUT,'hh24:mi;ss') - to_date(LOGIN,'hh24:mi;ss'))*24*60*60) mi
from gyh
group by yhm
)