change the date format from db to jsp

[bakiyalakshmi dhanraj]

hi,
In database i have date format in 19/03/2008 while i retrive the value in jsp, i need 19 march 2008 in this format.. can anyone tel me.

[pankaj patil]

Hi

its possibble in 2 ways
1) by converting the date in the db query itself by using to_date
2) by using simpleDateFormat in java

[Bear Bibeault]

If you are retrieving the date as a Date instance (rather than a string), you can simple use the <fmt:formatDate> JSTL tag on the JSP.