Re: Default Date Format...

maybe no one else has ever tried changing the NLS_DATE_FORMAT in the init.ora before. i know i haven't. then again, i've never relied on the setting of this parameter in any application either... and i don't rely on the setting at the session level either... you just never know when some DBA is going to come around and change things like this... lol.

i don't even know how to query the value of this parameter from the session level... is that what "show parameter" does ? i usually query the v$parameter table...

are there any initialization scripts or triggers that are run when you start svrmgrl or connect to the database ? have you tried the same thing in sqlplus ?

it must be something very simple that's being overlooked...

"The Tentative DBA...." <mick_rice_at_my-deja.com> wrote in message news:94rukd$kmc$1_at_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 Sat Jan 27 2001 - 23:33:48 CST