Advanced Search

Return to Snippet

Revision: 71026
at December 2, 2016 05:44 by bbrumm
Initial Code 
SELECT TO_DATE('16-OCT-2016')
FROM DUAL;

SELECT TO_DATE('16-10-2016', 'DD-MM-YYYY')
FROM DUAL;

SELECT TO_DATE('2016/10/14', 'YYYY/MM/DD')
FROM DUAL;

SELECT TO_DATE('20161012', 'YYYYMMDD')
FROM DUAL;

SELECT TO_DATE('08-10-2016', 'DD-MM-YYYY')
FROM DUAL;

SELECT TO_DATE('08-10-2016', 'DD-MM-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')
FROM DUAL;
Initial URL 
http://www.databasestar.com/oracle-to_date/
Initial Description 
These are some examples of the Oracle TO_DATE Function
Initial Title 
Oracle TO_DATE Examples
Initial Tags 
sql, Oracle
Initial Language 
SQL