Informe Reporte - Version - Duracion tiempo

 SQL FILTRANDO un REPORTE

select substr(jcfndfuf2,1,instr(jcfndfuf2,’_’,1)-1) REPORT , substr ( jcfndfuf2, instr(jcfndfuf2,’_’,1,1) +1  , instr(jcfndfuf2,’_’,1,2) - instr(jcfndfuf2,’_’,1,1)-1 ) VERSION ,
to_date(SUBSTR(jcsbmdate,2,6) || lpad(to_char(jcsbmtime),6,’0’),’YYDDDHH24MISS’) SUBMIT,
to_date(SUBSTR(JCACTDATE,2,6) || lpad(to_char(jcACTTIME),6,’0’),’YYDDDHH24MISS’) LAST,
(to_date(SUBSTR(JCACTDATE,2,6) || lpad(to_char(jcACTTIME),6,’0’),’YYDDDHH24MISS’) - to_date(SUBSTR(jcsbmdate,2,6) || lpad(to_char(jcsbmtime),6,’0’),’YYDDDHH24MISS’)) * 86400 seg ,
((to_date(SUBSTR(JCACTDATE,2,6) || lpad(to_char(jcACTTIME),6,’0’),’YYDDDHH24MISS’) - to_date(SUBSTR(jcsbmdate,2,6) || lpad(to_char(jcsbmtime),6,’0’),’YYDDDHH24MISS’)) * 86400 )/60 Min ,
((to_date(SUBSTR(JCACTDATE,2,6) || lpad(to_char(jcACTTIME),6,’0’),’YYDDDHH24MISS’) - to_date(SUBSTR(jcsbmdate,2,6) || lpad(to_char(jcsbmtime),6,’0’),’YYDDDHH24MISS’)) * 86400 )/360 hs
, jcsbmdate,jcsbmtime,jcjobque ,jcuser ,jcexehost,jcjobnbr
from svm900.f986110  where   jcfndfuf2 like ’R13800%’