Re: Setting NLS_DATE_FORMAT for SQL*PLUS
Date: Thu, 02 Jul 1998 17:09:34 GMT
Message-ID: <6ngesd$83c$1_at_nnrp1.dejanews.com>
In article <3598F77E.A33B0FDF_at_tde.ra.eunet.de>,
Burkhard Schultheis <bschultheis_at_tde.ra.eunet.de> wrote:
>
> I tried to set NLS_DATE_FORMAT in my login.sql file. I added a line
> alter session set nls_date_format = 'YYYY-MM-DD-HH24.MI.SS'
> but it does'nt work. The same command does work interactively in
> SQL*PLUS.
> What should I do instead?
> Burkhard Schultheis
> Tele Data Electronic
>
>
If you are running Windows95 or NT, alter your registry to include
Key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
String Value: "NLS_DATE_FORMAT"="YYYY-MM-DD24.MI.SS"
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 19:09:34 CEST