Re: NLS_DATE_FORMAT - Now what!!@!!!

There is a known bug with NT4.0 clients that it always defaults to the default value regardless of the init.ora parameter on the server the only way to override is via adding the nls_date_format to the clients registry.

Bob

Tansel Ozkan <tansel_at_openix.com> wrote in article <34DB3DDB.6C94_at_openix.com>...
> Jordan,
>
> I am having exactly the same problem in our Oracle 7.3 database running
> on NT 4.0. I did everything what the manual said but it doesn't seem to
> be working.
>
> Have you been able to find a solution?
>
> Thanks..
>
> Tansel
>
>
> Jordan Redner wrote:
> >
> > Why does everything with Oracle seem to be like pulling teeth?
> >
> > Probably because I don't know what the hell I'm doing yet.
> >
> > But anyway....Can someone help me?
> >
> > The NLS_DATE_FORMAT
> >
> > seems to work like a champ via the ALTER SESSION command.
> >
> > i.e.
> >
> > ALTER SESSION SET NLS_DATE_FORMAT = "mm-dd-yy"
> >
> > But when I put it in my initXXXX.ora file - it doesn't work
> > for squat.
> >
> > I even do a show parameter NLS_DATE_FORMAT and it looks like it
> > got set, yet when I do a
> >
> > select sysdate from dual;
> >
> > It still spits out the lame date format 04-Feb-98
> >
> > When I did the alter session command above, I got a nice
> > 02-04-1998
> >
> > Any help or guidance is greatly appreciated.
> >
> > Thanks in advance,
> >
> > Please responsd jordan_at_webnex.com
> >
> > Jordan
>
  Received on Wed Feb 11 1998 - 00:00:00 CST