NLS_DATE_FORMAT - Now what!!@!!!

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 04 1998 - 00:00:00 CST