Re: NLS_DATE_FORMAT

Well, I don't have solution..but, mentioning my experience regarding.

I've contacted oracle support a way back. But they could not replied me satisfactory. Actually, Only way I found is change registry file for each client you wants. It does not take into a effect when you change on server to client. If you run it from server, will work well. But same will try to execute from client. will give same result as you mentioned. Only way, I found is to make an entry to registry. and it's not a logical way, where we've many users working world-wide on same system.

Pl. let me know, if you find any other solution regarding.

Thanks,

Vrajesh.

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
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 20 1999 - 17:13:33 CDT