Re: How to set global date format?

From: <mjain_at_my-dejanews.com>
Date: Wed, 03 Feb 1999 06:47:33 GMT
Message-ID: <798re3$o67$1@nnrp1.dejanews.com>

You will have to change NLS_DATE_FOTMAT in the NT Registry. HKEY-LOCALMACHINE-->SOFTWARE-->ORACLE-->NLS_DATE_FORMAT Later you can check the value in the SQL_Plus session by doing a query on nls_session_parameters.

You can use following query.

select * from nls_session_parameters;

This will list parameters effecting your session.

Hope this helps,
Manoj Jain
Oracle Certified Professional - OCP DBA Chauncey Certified Oracle7 DBA

In article <36B5FAF4.DE992A02_at_flash.net>, Pankaj Asundi <asundi_at_flash.net> wrote:
> How do you set a global date format in Oracle 8.0.4.0 running on NT 4.0
> service pack 3.0? I was told to edit the registry? Is that correct?
> If it is what keys to change?
>
> Thanks for your help
>
> Pankaj Asundi
>
> asundi_at_flash.net
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 03 1999 - 00:47:33 CST