to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MONTH/DD HH12:MI:SS') : TO_TIMESTAMP « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TO_TIMESTAMP

to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MONTH/DD HH12:MI:SS')


SQL> select to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MONTH/DD HH12:MI:SS') from dual;

TO_TIMESTAMP('2003/DEC/1310:13:18','YYYY/MONTH/DDHH12:MI:SS')
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM

SQL>








Related examples in the same category

1.TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP
2.to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MONTH/DD HH24:MI:SS')
3.to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MONTH/DD HH:MI:SS')
4.to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MON/DD HH:MI:SS')