Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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. Received on Tue Apr 20 1999 - 12:26:27 CDT