wood burning stoves*
The moose likes Struts and the fly likes formatted Date from mysql, i m trying to display in jsp but its now working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "formatted Date from mysql, i m trying to display in jsp but its now working" Watch "formatted Date from mysql, i m trying to display in jsp but its now working" New topic
Author

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

Vinod suryawanshi
Ranch Hand

Joined: Aug 08, 2012
Posts: 51
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,

here i try to display it on browser

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
Bartender

Joined: Oct 14, 2005
Posts: 18887
    
    8

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

Joined: Aug 08, 2012
Posts: 51
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,

insted of


and i used

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: formatted Date from mysql, i m trying to display in jsp but its now working