Oracle SQL - Set the NLS_LANGUAGE parameter in to_char function

  1. HOME
  2. Oracle SQL
  3. Function
  4. TO_CHAR function

Introduction

You can set the NLS_LANGUAGE parameter to another language.

You can set the it per session or you can override this default at the statement level, by setting the NLS_DATE_LANGUAGE parameter.

Demo

SQL>
SQL> select to_char(sysdate, 'Day')
  2  ,      to_char(sysdate, 'Day', 'nls_date_language=Dutch')
  3  from   dual;

TO_CHAR(SYSDATE,'DAY')               | TO_CHAR(SYSDATE,'DAY','NLS_DATE_LANG
------------------------------------ | ------------------------------------
Saturday                             | Zaterdag

SQL>-- from w  w w. jav a 2 s .c om

Related Topic