Posted By

bbrumm on 01/14/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 01/14/17 05:18am

Statistics

Viewed 660 times

Favorited by 0 user(s)

Related snippets

Oracle TO_TIMESTAMP Function

/ Published in: SQL

A few examples of the Oracle TO_TIMESTAMP function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT TO_TIMESTAMP('16-09-2015 08:10:14 AM') AS TS_TEST
FROM dual;
 
SELECT TO_TIMESTAMP('12-09-2015 04:32:20.1245 PM', 'DD-MM-YYYY HH:MI:SS.FFFF AM') AS TS_TEST
FROM dual;
 
SELECT TO_TIMESTAMP('8 DEC 2015 10:04', 'DD MON YYYY HH:MI') AS TS_TEST
FROM dual;