Oracle TO_DATE

Posted on 11.15.2011 by admin

Function Description

Function TO_DATE returns the value of DATE datatype from a VARCHAR2, NVARCHAR2, CHAR, NCHAR datatype.

Here you will find Oracle date format elements.

Examples

SELECT TO_DATE('23.07.2011', 'DD.MM.YYYY')
  FROM dual

Result: 23.07.2011

SELECT TO_DATE('23.07.2011 15:43:46', 'DD.MM.YYYY HH24:MI:SS')
  FROM dual

Result: 23.07.2011 15:43:46

SELECT TO_DATE('18 JULY 2011', 'DD MONTH YYYY')
  FROM dual

Result: 18.7.2011
This entry was posted in Oracle SQL Functions. Bookmark the permalink.