making java.sql.Date dd.mm.yyyy format

[Former Member]

Hi,

java.sql.Date format is m/d/yyyy.

I must use dd.mm.yyyy format.

How can it be done?

Thanks.

[Former Member · Accepted solution]

You can use the following line of code to change the date format

SimpleDateFormat formatter = new SimpleDateFormat("dd.MM.yyyy");

String formattedDate = formatter.format(<Ur java.sql.Date instance>);

Edited by: Santhosh Edla on Sep 7, 2009 5:00 PM

[Former Member · Accepted solution]

Here is SimpleDateFormat API link

http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

[Former Member · Accepted solution]

Hi,

We need formatted output must be date type not string.

Thanks.

[Former Member · Accepted solution]

AFAIK Formatted dates will be of string type only.

What is your exact requirement? What do you want to do with the so called formatted date of DATE type only?