Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. 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>