Posted By

bbrumm on 12/02/16

Tagged

sql
Oracle

Versions (?)

Last Edited at 12/02/16 05:44am

Statistics

Viewed 615 times

Favorited by 0 user(s)

Related snippets

Oracle TO_DATE Examples

/ Published in: SQL

These are some examples of the Oracle TO_DATE Function

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;