Hi,
Please help me converting the above string to timestamp. I tried below, but not working-
select to_char(TO_DATE(Translate(SUBSTR ( '2009-12-22T22:10:57.767+0000' , 1, 19),'T',' '),'YYYY-MM-DD HH24:MI:SS'),'MM-DD-YYYY HH24:MI:SS') from dual;
DB: Oracle 12C