to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MON/DD HH:MI:SS')
SQL> select to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MON/DD HH:MI:SS') from dual;
TO_TIMESTAMP('2003/DEC/1310:13:18','YYYY/MON/DDHH:MI:SS')
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>
Related examples in the same category