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

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/04
Message-ID: <34d8e869.31422994@www.sigov.si>#1/1

On 4 Feb 1998 20:50:47 GMT, jordan_at_webnex.com (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,

Set NLS_DATE_FORMAT in your *CLIENT* environment and you'll be fine. I.e. oracle.ini in ORAWIN, registry in ORAWIN95/ORANT, shell "set environment variable" on UNIX, .....

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Feb 04 1998 - 00:00:00 CST