alter session set nls_date_format='dd-mm-yyyy', nls_language=Dutch, nls_currency='Eur' : nls_date_format « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. nls_date_format
SQL> alter session
  2  set   nls_date_format='dd-mm-yyyy'
  3        nls_language=Dutch
  4        nls_currency='Eur';

Session altered.

SQL>
SQL>








29.15.nls_date_format
29.15.1.alter session set nls_date_format='dd-mm-yyyy'
29.15.2.alter session set nls_date_format = 'SYYYYMMDD HH24MISS';
29.15.3.alter session set nls_date_format='dd-mm-yyyy', nls_language=Dutch, nls_currency='Eur'