In a oracle table column, there is a
varchar2 column which contains value
'2017-02-14T18:04:34.988+00:00' I need to convert it to timestamp. I am using
TO_TIMESTAMP() to convert but I am not able to find out what date mask I need to provide. I have tried with
sql> select to_timestamp('2017-02-14T18:04:34.988+00:00','YYYY-MM-DD HH24:MI:SS.FF') from dual ;
But it does not work.
Kindly suggest what datetime mask I have to specify as 2nd argument.