0 and ((to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) + (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS'))) * 86400 > 180 and t1.leadd is not null then to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') when (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.Lagg, 'YYYYMMDDHH24MISS')) * 86400 > 3600.1 and (to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - to_date(t1.Lagg, 'YYYYMMDDHH24MISS')) * 86400 > 180 then to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour')) when t1.leadd is null and (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 > 180 then to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') when t1.lagg is null and (to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour'))) * 86400 > 180 then to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour')) else 0 end k, case when substr(t1.Leadd, 0, 10) = substr(t1.MILL_DTIME, 0, 10) and (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 > 180 then (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 else 0 end sjc, t1.ACT_WGT from (select t.MILL_DTIME, substr(to_char(to_date(t.MILL_DTIME, 'YYYYMMDDHH24MISS') + numtodsinterval(1, 'hour'), 'YYYYMMDDHH24MISS'), 0, 10) || '0000' MILL_DTIME2, Lead(t.MILL_DTIME) OVER(ORDER BY t.MILL_DTIME) leadd, lag(t.MILL_DTIME) OVER(ORDER BY t.MILL_DTIME) lagg, t.ACT_WGT from tbh02_coil_comm t where substr(t.MILL_DTIME,0,8) between ? and ? ORDER BY t.MILL_DTIME) t1) t2 group by substr(t2.MILL_DTIME, 0, 10) order by substr(t2.MILL_DTIME, 0, 10)) t3 ]]> 0 and ((to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) + (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS'))) * 86400 > 180 and t1.leadd is not null then to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') when (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.Lagg, 'YYYYMMDDHH24MISS')) * 86400 > 3600.1 and (to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - to_date(t1.Lagg, 'YYYYMMDDHH24MISS')) * 86400 > 180 then to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour')) when t1.leadd is null and (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 > 180 then to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') when t1.lagg is null and (to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour'))) * 86400 > 180 then to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour')) else 0 end k, case when substr(t1.Leadd, 0, 10) = substr(t1.MILL_DTIME, 0, 10) and (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 > 180 then (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 else 0 end sjc, t1.ACT_WGT from (select t.MILL_DTIME, substr(to_char(to_date(t.MILL_DTIME, 'YYYYMMDDHH24MISS') + numtodsinterval(1, 'hour'), 'YYYYMMDDHH24MISS'), 0, 10) || '0000' MILL_DTIME2, Lead(t.MILL_DTIME) OVER(ORDER BY t.MILL_DTIME) leadd, lag(t.MILL_DTIME) OVER(ORDER BY t.MILL_DTIME) lagg, t.ACT_WGT from C_TBC02_COIL_COMM t where t.LINE_TP = 'L' and t.COIL_STAT in ('2', '3') and t.DIVIDE_YN not in ('X', 'Y') and substr(t.MILL_DTIME,0,8) between ? and ? ORDER BY t.MILL_DTIME) t1) t2 group by substr(t2.MILL_DTIME, 0, 10) order by substr(t2.MILL_DTIME, 0, 10)) t3 ]]> 0 and ((to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) + (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS'))) * 86400 > 180 and t1.leadd is not null then to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') when (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.Lagg, 'YYYYMMDDHH24MISS')) * 86400 > 3600.1 and (to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - to_date(t1.Lagg, 'YYYYMMDDHH24MISS')) * 86400 > 180 then to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour')) when t1.leadd is null and (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 > 180 then to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') when t1.lagg is null and (to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour'))) * 86400 > 180 then to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS') - (to_date(t1.MILL_DTIME2, 'YYYYMMDDHH24MISS') - numtodsinterval(1, 'hour')) else 0 end k, case when substr(t1.Leadd, 0, 10) = substr(t1.MILL_DTIME, 0, 10) and (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 > 180 then (to_date(t1.Leadd, 'YYYYMMDDHH24MISS') - to_date(t1.MILL_DTIME, 'YYYYMMDDHH24MISS')) * 86400 else 0 end sjc, t1.ACT_WGT from (select t.MILL_DTIME, substr(to_char(to_date(t.MILL_DTIME, 'YYYYMMDDHH24MISS') + numtodsinterval(1, 'hour'), 'YYYYMMDDHH24MISS'), 0, 10) || '0000' MILL_DTIME2, Lead(t.MILL_DTIME) OVER(ORDER BY t.MILL_DTIME) leadd, lag(t.MILL_DTIME) OVER(ORDER BY t.MILL_DTIME) lagg, t.ACT_WGT from C_TBL02_COIL_COMM t where substr(t.MILL_DTIME,0,8) between ? and ? ORDER BY t.MILL_DTIME) t1) t2 group by substr(t2.MILL_DTIME, 0, 10) order by substr(t2.MILL_DTIME, 0, 10)) t3 ]]>