Oracle TO_TIMESTAMP Function


/ Published in: SQL
Save to your folder(s)

A few examples of the Oracle TO_TIMESTAMP function.


Copy this code and paste it in your HTML
  1. SELECT TO_TIMESTAMP('16-09-2015 08:10:14 AM') AS TS_TEST
  2. FROM dual;
  3.  
  4. SELECT TO_TIMESTAMP('12-09-2015 04:32:20.1245 PM', 'DD-MM-YYYY HH:MI:SS.FFFF AM') AS TS_TEST
  5. FROM dual;
  6.  
  7. SELECT TO_TIMESTAMP('8 DEC 2015 10:04', 'DD MON YYYY HH:MI') AS TS_TEST
  8. FROM dual;

URL: http://www.databasestar.com/oracle-to_timestamp/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.