Question Re: making java.sql.Date dd.mm.yyyy format in Technology Q&A

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

Former Member — Mon, 07 Sep 2009 13:55:30 GMT

Hi,

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

I must use dd.mm.yyyy format.

How can it be done?

Thanks.

Former Member — Mon, 07 Sep 2009 14:00:43 GMT

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 — Mon, 07 Sep 2009 14:04:10 GMT

Here is SimpleDateFormat API link

Former Member — Mon, 07 Sep 2009 14:18:03 GMT

Hi,

We need formatted output must be date type not string.

Thanks.

Former Member — Mon, 07 Sep 2009 14:21:26 GMT

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?