Re: Urgent Help

Hello All,
if you set the environment variable NLS_DATE_FORMAT with the proper format that you need, should do the trick.
There is no need to change and/or modify the registry. Hope this helps.

"Stephane" <sahki_at_sympatico.ca> wrote in message news:QZxv6.465397$Pm2.7188837_at_news20.bellglobal.com...
> Changing the INIT.ORA in the server does not work.
>
> You have to change in the client side:
>
> - Registry: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and add NEW STRING VALUE
> NLS_DATE_FORMAT to the proper format. This will affect all application
> automatically
> - Change the client application with ALTER SESSION SET ... just after
 first
> connection to the server.
>
> "iqbalkhan1" <iqbalkhan1_at_email.msn.com> wrote in message
> news:eHwaf#asAHA.292_at_cpmsnbbsa09...
> > Hi,
> > I want to store the date values as MM/DD/YY. I need to change this
> > globally and even I have changed into init.ora file
> > NLS_DATE_FORMAT = "MM/DD/YY"
> > but not succeeded.
> > Hope I would expect some good solution from the group.
> > Thanks
> >
> >
> > --
> > -----------------------------------------------------
> > Click here for Free Video!!
> > http://www.gohip.com/free_video/
> >
> >
> >
>
>
Received on Thu Mar 29 2001 - 04:10:50 CEST