Default Date Format...

From: The Tentative DBA.... <mick_rice_at_my-deja.com>
Date: Fri, 26 Jan 2001 13:38:21 GMT
Message-ID: <94rukd$kmc$1@nnrp1.deja.com>

I'm just experimenting with the default date format on an 8.1.6 test database here and adjusting the init parameter NLS_DATE_FORMAT. I had been under the impression that if I adjusted the parameter then the default date specification for the database followed. It appears not to be that simple. I must be missing something very simple !

SVRMGR> show parameter nls_date_format;

NAME                                TYPE    VALUE


----------------------------------- -------

------------------------------

nls_date_format                     string  DD-MON-

YYYY
SVRMGR> select sysdate from dual;
SYSDATE

---

26-JAN-01
1 row selected.
SVRMGR> select to_char(sysdate) from dual; TO_CHAR(S

---

26-JAN-01
1 row selected.
SVRMGR>

--


Sent via Deja.com
http://www.deja.com/

Received on Fri Jan 26 2001 - 07:38:21 CST