TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP : TO_TIMESTAMP « Date Timezone « Oracle PL / SQL

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

TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP

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>




           
       

Related examples in the same category