alter session set nls_date_format = 'SYYYYMMDD HH24MISS'; : 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>
SQL>
SQL> alter session set nls_date_format = 'SYYYYMMDD HH24MISS';

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'