Oracle TO_TIMESTAMP Function - SQL Snipplr Social Repository

Revision: 71086

at January 14, 2017 05:18 by bbrumm

Initial Code

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;

Initial URL

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

Initial Description

A few examples of the Oracle TO_TIMESTAMP function.

Initial Title

Oracle TO_TIMESTAMP Function

Initial Tags

sql, Oracle

Initial Language

SQL

Choose a language for easy browsing: