Re: NLS_DATE_FORMAT - Now what!!@!!!

From: Willem Dekker <dekker_at_serc.nl>
Date: 1998/02/12
Message-ID: <34E2DCF2.23C1929A@serc.nl>#1/1

Ken-ming Wang wrote:

> In Windows NT, You can alter the NLS_DATE_FORMAT BY TWO WAYS :
> 1. alter session set nls_date_format = 'mm-dd-yy' ;
> 2. run regedt32 registry utility :
> HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE
> add the string named NLS_DATE_FORMAT, its value is
> mm-dd-yy
> Anyway, It can't be put in the initorcl.ora initial parameter file.
Actually you also alter the NLS_DATE_FORMAT with an environment variable

This does work with the command line and the gui version of SQL*Plus

Willem
screendump below:
c:\>set NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS

c:\>plus33
SQL*Plus: Release 3.3.3.0.0 - Production on Thu Feb 12 11:47:46 1998 Enter user-name: system/manager
Connected to:
Oracle Server Release 7.3.3.3.0 - Production Release With the distributed, replication and parallel options PL/SQL Release 2.3.3.3.0 - Productiosn

SQL> select sysdate from dual

SYSDATE

---

1998-02-12 11:47:32

SQL>exit Received on Thu Feb 12 1998 - 00:00:00 CST