Re: Urgent Help

From: Kenny Gump <kgump_at_mylanlabs.comnospam>
Date: Wed, 21 Mar 2001 14:23:32 -0500
Message-ID: <3ab8ffd4_2_at_News.Mountain.Net>


Set your environment variable NLS_DATE_FORMAT='MM/DD/YY'

I know in Oracle 8i if you set NLS_LANG (which you need to) it will set a default date format for the system and override init.ora

Kenny

"iqbalkhan1" <iqbalkhan1_at_email.msn.com> wrote in message news:eHwaf#asAHA.292_at_cpmsnbbsa09...
> Hi,
> I want to store the date values as MM/DD/YY. I need to change this
> globally and even I have changed into init.ora file
> NLS_DATE_FORMAT = "MM/DD/YY"
> but not succeeded.
> Hope I would expect some good solution from the group.
> Thanks
>
>
> --
> -----------------------------------------------------
> Click here for Free Video!!
> http://www.gohip.com/free_video/
>
>
>
Received on Wed Mar 21 2001 - 20:23:32 CET

Original text of this message