Oracle SQL - Set the NLS_LANGUAGE parameter in 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 ww  .j  ava 2 s  . c  o m

Related Topic