SQL>
SQL> --TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP.
SQL>
SQL> select to_timestamp('2003/12/13 10:13:18', 'YYYY/MM/DD HH:MI:SS') from dual;
TO_TIMESTAMP('2003/12/1310:13:18','YYYY/MM/DDHH:MI:SS')
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>