Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>