You can see the difference by inserting into a date field and setting the
session to display in the required format(dd/mm/yyyy hh24:mi:ss). If the
parameter is set properly then it'll display non-zero values for hh24:mi:ss.
nls_date_format setting affects only internal storage of date values. For
display, use formatting.


-----Original Message-----
From: Pallavi Tingare [mailto:[Email Address Removed] Monday, June 30, 2003 12:56 PM
To: LazyDBA.com Discussion
Subject: RE: NLS_DATE_FORMAT problem.....With 9i DB::::::Please
help..Its urgetn & I am not able to find any leads on net either!!!




"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 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