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

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 Fri Feb 06 1998 - 00:00:00 CST