Re: Default Date Format...

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Fri, 26 Jan 2001 15:24:30 +0100
Message-ID: <3A71889D.5C14909B@cern.ch>

Hello,

alter session

SQL> alter session set nls_date_format='DD-MON-YYYY';

SQL> select sysdate from dual;

SYSDATE

---

26-JAN-2001 Hth,

Erika

"The Tentative DBA...." wrote:
>
> 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 - 08:24:30 CST