Re: How do I change nls_date

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Mon, 3 Jan 2000 09:13:06 +0100
Message-ID: <84plmj$pnh$1@mail.messe.de>

Another possibility is via ALTER SESSION :

SQL> alter session set nls_date_format='YYYY-MM-DD HH24:MM:SS';

Hth,
Reiner

Peter Bryant <pbryant_at_bigfoot.NOSPAM.com> schrieb in im Newsbeitrag: 946886348.348959_at_shelley.paradise.net.nz...
> How do I change nls_date_format on Oracle 8 for NT. I've set the registry
> key:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_DATE_FORMAT
>
> and editted the init.ora file.
>
> Anyone have any further ideas? Basically, I want it to recognise
> 'YYYY-MM-DD' with an optional HH24:MM:SS.
>
> TIA
>
> - Peter Bryant
>
>
>
>
Received on Mon Jan 03 2000 - 02:13:06 CST

Re: How do I change nls_date_format?