Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

TO_TIMESTAMP(x)

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>