NLS_DATE_FORMAT

From: <mgopalani_at_my-dejanews.com>
Date: 1999/04/20
Message-ID: <7fghdt$bt2$1@nnrp1.dejanews.com>#1/1

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 - 00:00:00 CDT