Forums Register Login

Date Problem

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.

+Pie Number of slices to send: Send
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.


Beware the other head of science - it bites! Nibble on this message:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1358 times.
Similar Threads
How to convert String to Date
Date Validation
How to fetch Date Field from excel sheet in Java
conversion of date
How to determine Data Format while we are getting Data from Excel Sheet
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 05:50:58.