Help with NLS_DATE_FORMAT

From: <alt_at_interchange.co.uk>
Date: Thu, 04 Mar 1999 17:10:51 GMT
Message-ID: <7bmeqh$m2g$1@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:10:51 CST