Re: R: Specifying NLS_DATE_FORMAT

Normally, yes I would restart the database after such a change, but in this case I was making the change through Enterprise Mgr, and it indicated that it would apply the change on the fly.

Even if that were the case, it still should have been overridden for a specific client when I made the change in the client's registry.

In article <7vpcm8$18e$1_at_nslave1.tin.it>,   "Riccardo Ferrari" <riccardo.ferrari_at_informatica2.it> wrote:
> > If I put this in my INIT<sid>.ORA file:
> >
> > nls_date_format = 'MM-DD-YYYY HH24:MI:SS'
> >
> > I see no difference in my SELECT statement.
>
> I find this very strange ... I know (and I've also just tried) that
it must
> really change the date format.
> Just a silly question: you know you have to shutdown and restart the
> instance after changing the parameter file, do you?
> I really don't find any other sensible explanation.
>
> Bye
> Riccardo
>
> Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote in message
> 7vmvqj$1qq$1_at_nnrp1.deja.com...
> > I have a question about the use of the NLS_DATE_FORMAT parm. If I
> > don't have it set anywhere, then I see this:
> >
> > SQL> select sysdate from dual;
> >
> > SYSDATE
> > ---------
> > 02/NOV/99
> >
> Do I misunderstand, or am I
> > missing something that is supposed to be obvious?
> >
> > - Ed Stevens
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Ed Stevens
(Opinions are not necessarily those of my employer)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 04 1999 - 06:55:50 CST