Re: NLS Database Parameters vs. NLS Instance Parameters

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 7 Dec 2004 06:55:43 +0100
Message-ID: <41b544f9$0$20230$626a14ce@news.free.fr>

"Craig & Co." <crb_at_amsa.gov.au> a écrit dans le message de news:41b4d064$0$29515$c30e37c6_at_ken-reader.news.telstra.net...
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message
> news:41b3effc$0$32761$626a14ce_at_news.free.fr...
> >
> > "Craig & Co." <crb_at_amsa.gov.au> a écrit dans le message de
> > news:41b3ddd9$0$29529$c30e37c6_at_ken-reader.news.telstra.net...
> > > Hi,
> > >
> > > What is the difference between NLS_DATABASE_PARAMETERS
> > > and NLS_INSTANCE_PARAMETERS?
> > >
> > > Craig.
> > > --
> >
> > "NLS_DATABASE_PARAMETERS lists permanent NLS parameters of the database."
> > That is set at the database creation.
> > "NLS_INSTANCE_PARAMETERS lists NLS parameters of the instance."
> > That is set by the init.ora or spfile (or alter system command for a few
> of them).
> >
> > Regards
> > Michel Cadot
> >
> Hi Michel,

>

> Which settings are used by sysdate?

>

> Craig.

>
>

What do you mean? sysdate don't use a format, sysdate is a date. Maybe you think of display format when you execute something like: select sysdate from dual
In this case, this nls_session_parameters or v$nls_parameter you have to search in to know the default output date format.

Regards
Michel Cadot Received on Mon Dec 06 2004 - 23:55:43 CST