Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

Converting German date to DATE format

SQL> SQL> -- Converting German date to DATE format. SQL> SELECT TO_DATE('februar-23','MONTH-DD','NLS_DATE_LANGUAGE=german') "Converted" from DUAL; Converted --------- 23-FEB-06 SQL>