Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

Converting a DATE to Another Language

SQL> SQL> SELECT TO_CHAR(SYSDATE,'MONTH DD YY','NLS_DATE_LANGUAGE=german')   2  "German Date" from dual; German Date --------------- JUNI      02 07 SQL>