• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Date Problem

 
barnali chakrabarty
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi:
I use MySql as database and I need to retrieve a date field (in yyyy-mm-dd format) and show it in dd-mm-yyyy format as a String.Is it possible? Can anybody help please?
Codes will be welcome.
Thanks.
 
Andrew Obodoefuna
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Assuming that you obtain the date from mySQL through a resultSet i.e. resultset.getDate(int), the java.util.Date object returned (date) can be parsed like so:
SimpleDateFormat format = (SimpleDateFormat) DateFormat.getDateInstance();
format.applyPattern("dd-MM-yyyy");
String formattedDate = format.format(date);
You can perform this piece of code in your responding servlet or through a JSP taglib that takes in the java.util.Date as an argument in the JSP and performs the logic in its tag class.
For a decent datetime JSP taglib see: http://jakarta.apache.org/taglibs/doc/datetime-doc/intro.html
Alternatively you can easily write one yourself.
AO.

 
Pranit Saha
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You will get the answer in this thread.. It worked fine..
http://www.javaranch.com/ubb/Forum50/HTML/000351.html
Pranit..

Originally posted by barnali chakrabarty:
Hi:
I use MySql as database and I need to retrieve a date field (in yyyy-mm-dd format) and show it in dd-mm-yyyy format as a String.Is it possible? Can anybody help please?
Codes will be welcome.
Thanks.

 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic