Re: Date format default issue

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 10 Dec 1999 21:02:08 +0100
Message-ID: <944856176.15870.0.pluto.d4ee154e@news.demon.nl>

Yes, you need to change the registry on ALL clients, or put the alter session in your login.sql and use a network drive for that. Of course this addresses the issue for sqlplus only.

Hth,

--
Sybrand Bakker, Oracle DBA
Mark K <markko99_at_my-deja.com> wrote in message news:82ritr$b22$1_at_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 - 14:02:08 CST