Formato Juliano - Date

 

select TO_DATE(SUBSTR(110026,2,6),’YYDDD’ ) FROM DUAL

 

select jcprocessid,jcsbmdate,jcsbmtime,
to_date(SUBSTR(jcsbmdate,2,6) || lpad(to_char(jcsbmtime),6,’0’),’YYDDDHH24MISS’) FECHA_SUBMIT,
to_date(SUBSTR(JCACTDATE,2,6) || lpad(to_char(jcACTTIME),6,’0’),’YYDDDHH24MISS’) FECHA_FIN,
(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

TIEMPO_TRANSCURRIDO_SEG
from svm900.f986110