Converting German date to DATE format : I18N « Char Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Char Functions
3. I18N

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>


           
       

Related examples in the same category