Re: R: Specifying NLS_DATE_FORMAT

I can't say about 8i, but if you'll re-read my original post (the one that started this thread) you'll see that setting the registry didn't work for me under 8.0.

In article <7vqki3$ekf$1_at_ffx2nh3.news.uu.net>,   "John F. Keaveney" <johnkeaveney_at_targusinfo.com> wrote:
> If you want to change this on NT you need to add a registry key under
> 8i: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
> pre 8i: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
>
> Create a new string value called NLS_DATE_FORMAT and
> set it using standard Oracle date format.
>
> e.g. mine is
> YYYY-MM-DD HH24:MI:SS
>
> Thanks,
> John
>
> <patcyr_at_my-deja.com> wrote in message
news:7vpkev$vnr$1_at_nnrp1.deja.com...
> > I had the same problem and even with restarting the computer it
didn't
> > change anything. If you find the answer let me know.
> >
> > bye
> > Patcyr
> >
> > 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.
> > >
> > >
> >
> >
> > 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:57:58 CST