Hi,
I am facing a wierd problem with NLS_DATE_FORMAT...
I want to setup my database for a particular date format as 'MM/DD/YYYY
HH:MI:SS'.. So I made the corresponding entries in init.ora as well as SP
file for my instance... I restarted the DB after making the changes..
But when I select date from the dual I get the old date
format('29-Jun-2003') only..Why isnt the NLS_DATE_FORMAT from the init.ora
or spfile getting reflected..Is there any other place where also I have to
make these entries...??? The database version I am working on is 9i.
Please help..
Regards,
Pallavi.

"Courage doesn't always roar. Sometimes courage is the quiet voice at the
end of the day saying, 'I will try again tomorrow.'"

Oracle LazyDBA home page