,TO_DATE(E.HCALL_DT, 'yyyymmdd') AS HCALL_DT
,TO_DATE(E.HCALL_TIME, 'hh24miss') AS HCALL_TIME
,TO_DATE(E.HCALL_DT, 'yyyymmdd') AS HCALL_DT
,TO_DATE(E.HCALL_TIME, 'hh24miss') AS HCALL_TIME