Oracle PL/SQL/Char Functions/I18N

Converting DATE to another language

   <source lang="sql">

SQL> SQL> SQL> -- Converting DATE to another language. SQL> SELECT TO_CHAR(SYSDATE,"MONTH DD YY","NLS_DATE_LANGUAGE=german") "German Date" from DUAL; German Date

---

AUGUST 31 06 SQL> SQL>

      </source>
   
  

Converting German date to DATE format

   <source lang="sql">

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>

      </source>