Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. Converting DATE to another language
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>