Re: Default Date Format...

Spencer,

        Thanks for the answer. Yeah, that's how I normally check a parameter, ie show parameters blah_blah. All params including the string given are returned. I agree that I must be missing something simple, but I'd dearly love to know what it is, just out of curiosity,

Mick.

In article <2bOc6.608$Yq5.207826_at_nnrp2.sbc.net>,   "Spencer" <spencerp_at_swbell.net> wrote:
> 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/
> >
>
>

--
If it isn't backed up, it's not worth shit !


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