Re: Help with NLS_DATE_FORMAT

I believe the *client* NLS_DATE_FORMAT is determined by registry settings...

Glenn Baron

alt_at_interchange.co.uk wrote in article <7bmeqh$m2g$1_at_nnrp1.dejanews.com>...
> Oracle 7.3.2.3
> sqlnet 2.3.4
> decalpha running decunix
>
>
> Any idea whats going on here?
>
> We've got NLS_DATE_FORMAT="YYYYMMDD" set in the init.ora file and when
you use
> sqlplus on the server it returns the date in the correct format eg
>
> select sysdate from dual;
>
> sysdate
> ---------
> 19990304
>
> When you use sqlplus from the client you get a different result!
>
> select sysdate from dual;
>
> sysdate
> ---------
> 03-MAR-99
>
> Could someone please explain why this is happening. It's causing havoc
with
> our client application which expects the date in the YYYYMMDD format.
>
> I'd be grateful for a reply to alt_at_interchange.co.uk
>
> Thanks for the help.
>
> Al
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Thu Mar 04 1999 - 11:26:59 CST