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

On 11 Feb 1998 01:27:00 GMT, "bhawk1" <bhawk1_at_sprynet.com> wrote:

>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
>
>>> > 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.
>> > 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

In Windows NT, You can alter the NLS_DATE_FORMAT BY TWO WAYS :

1. alter session set nls_date_format = 'mm-dd-yy' ;
2. run regedt32 registry utility : HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE add the string named NLS_DATE_FORMAT, its value is mm-dd-yy Anyway, It can't be put in the initorcl.ora initial parameter file.
   • Slight Heart, Thousand Miles. Ken-ming Wang ***
   • MCSE & CNE/CNI Certified Sys. Engineer *** FROM
   • LGS 3d*/Administrator On LGS Go Server ***
   • Welcome to LGS. http://www.lgs.hinet.net *** R.O.C