Converting DATE to another language : I18N « Char Functions « Oracle PL / SQL

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

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>
           
       

Related examples in the same category