Skip to Main Content

Endeca Experience Management

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Please Ignore this question - Convert YYYY-MM-DDTHH:mm:ss.000+0000 format to Timestamp

RameshSagarApr 28 2021 — edited Apr 28 2021

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

Comments
Post Details
Added on Apr 28 2021
2 comments
261 views