Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NLS_DATE_FORMAT on server - 8.1.5
I just updated by server ( Netware) to Oracle 8.1.5 and, after a few hiccups, all went well; I cannot, however, seen to set the NLS_DATE_FORMAT for the database...
Mt init<sid>.ora file ( the one in the pfile directory called by the one in the
database directory ) has
NLS_DATE_FORMAT = "DD-MON-YYYY"
Yet when I do a select sysdate from dual ( at the console with svrmgr31) I get
15-MAY-00
I removed, at Oracle Tech's suggestion, all NLS_ references in the config.ora
file, but It didn't help...
any Ideas ?
Thanks,
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon May 15 2000 - 00:00:00 CDT