Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

To_timestamp(2003DEC13 10

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>