Re: NLS_DATE_FORMAT

mgopalani_at_my-dejanews.com wrote:
>
> Hello Friends,
> I have a funny situation. Hope some one could provide me with a solution.
>
> WE have an Oracle 7.3 database hosted on Windows NT.
> In the initialization files we have mentioned the parameter
> NLS_DATE_FORMAT = "dd-mon-yyyy"
> The database and the instance was brought down and restarted.
>
> On checking the v$parameter file it shows that the setting
> for NLS_DATE_FORMAT = "dd-mon-yyyy".
>
> When we execute "select sysdate from dual;" it returns the
> sysdate in 2 digit year format. We fail to understand why.
>
> Would be happy if some one could provide us with a solution for it.
>
> Thanks
>

Are you getting this on an NT or 95/98 box? If so, it is because of a Registry setting on the client. I forget the Registry name, but do a serch for NLS_DATE in regedt32 and change the format.

Michael.

-- 
Michael A. Rothwell
Oracle DBA/Oracle Web Applications Developer

Views expressed here are not those of my company 
No - Actually - Since I am independent, They are the views of my company.