LS_DATE_FORMAT
$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 6 20:23:57 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: someuser
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select sysdate from dual;
SYSDATE
------------------
06-DEC-07
SQL> alter session set nls_date_format='YYYY-MM-DD HH:MI:SS';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2007-12-06 08:22:37
DataBase 설정 되어 있는 초기 파라미터들은 NLS_DATABASE_PARAMETERS View에서 조회 할 수 있다.
SQL> select * from nls_database_parameters
2 where parameter = 'NLS_DATE_FORMAT';
PARAMETER
------------------------------
VALUE
---------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RR
