Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> NLS_DATE_FORMAT
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
![]() |
![]() |