Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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      16 08 1 row selected. SQL> SQL> SQL> SQL> --