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


-----Original Message-----
From: Pallavi Tingare [mailto:[Email Address Removed] Monday, June 30, 2003 11:46 AM
To: LazyDBA.com Discussion
Subject: NLS_DATE_FORMAT problem.....With 9i DB


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page