formatted Date from mysql, i m trying to display in jsp but its now working

[Vinod suryawanshi]

Hi,

I am trying to to format my date which i m taking from mysql tabel. The date datatype in mysql table is timestamp. bellow is my sql statement,

sqlpage = "SELECT name,DATE_FORMAT(date,'%Y-%m-%d %H:%i %p') from sttable order by date desc";

here i try to display it on browser

 <td><%=rspage.getString("date")%></td>

but its not working... i know that there is some problem with getString method of datatype mismatch, but i am unable to find it?
If Anybody have any idea about it, the please help me?

Thanks in advanced....

[Paul Clapham]

"Not working"? Please read our FAQ page ItDoesntWorkIsUseless (yes, follow that link) and then post some more information so that we can help you.

[Vinod suryawanshi]

Thanks for your reply Paul Clapham,
and sorry for comment-"No working".

i have timestamp datatype for date in mysql table, so when i try to display date on on web site it look like,
"2012-07-18 11:40:44.0"- here extra 0 is coming after "11:40:44" i want to remove that....

so i use sql query,

select DATE_FORMAT(date,'%Y-%m-%d  %h:%i:%p') from sttable

insted of

select date from sttable

and i used

<td><%=rspage.getString("date")%></td>

to get values from resultset, so that i can display them on browser.

But when i try to run this .jsp page,
my page was display with half information, like i have 4 textfield, label and one submit button on page.
But only first 2 textfield and labels are getting display. the rest of page is not getting display....

Hope you understand whats my error is, if you have suggestion then please help me,
Thanks in advanced