Re: Setting NLS_DATE_FORMAT for SQL*PLUS
From: Michael <michael1_at_xs4all.nl>
Date: Tue, 30 Jun 1998 18:51:58 +0200
Message-ID: <359917AE.F9425DC9_at_xs4all.nl>
Date: Tue, 30 Jun 1998 18:51:58 +0200
Message-ID: <359917AE.F9425DC9_at_xs4all.nl>
Burkhard Schultheis schreef:
> 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
You can make an entry in your registry (assuming you use Windows '95 on NT)Go to HKEY-LOCAL-MACHINE >> Software>>Oracle Make a string NLD_DATE_FORMAT and enter your settings. Received on Tue Jun 30 1998 - 18:51:58 CEST