Date format default issue

From: Mark K <markko99_at_my-deja.com>
Date: Fri, 10 Dec 1999 19:05:33 GMT
Message-ID: <82ritr$b22$1@nnrp1.deja.com>

Can't get my database data format to default to 'mm/dd/yyyy'. HAve done the following:
1. Set NLS_DATE_FORMAT in the initialization file. No results. 2. Set NLS_DATE_FORMAT in the Windows registry. Now it works correctly only on the server, but still uses dd-mon-yy on client machines.
3. Alter sessions set nls_date_format works fine. Of course only for that session. Need it on all sessions for application.

NT server, Oracle 8.0.5. Any thoughts will be appreciated.

--
Mark

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 13:05:33 CST