date format

[Aditi agarwal]

i have a date field in my database in format (yyyy-mm-dd)

i want to convert it into following format

(dd-mm-yyyy)

please help me

[Swastik Dey]

Look into DateFormat/SimpleDateFormat class.

String currentDate="2011-04-20";
        DateFormat sdf=new SimpleDateFormat("yyyy-mm-dd");
        Date dt=null;
        try{
			dt=sdf.parse(currentDate);
			sdf=new SimpleDateFormat("dd-mm-yyyy");
			String formattedDate=sdf.format(dt);
			System.out.println(formattedDate);
		}
		catch(Exception e){}

[Aditi agarwal]

thanks swstik for your reply but do we need to import any class in our page for this because its showing error that


DateFormat & SimpleDateFormat cannot be resolved


please help
thank you

[Swastik Dey]

Yes Aditi, you need the following two

java.text.DateFormat
java.text.SimpleDateFormat

[Aditi agarwal]

The method parse(String) in the type DateFormat is not applicable for the arguments (Date)

this problem arises at word parse

please help

[Swastik Dey]

parse method takes String as an argument, but probably your code is passing a Date type reference to it.

[Swastik Dey]

And if that is the case, try the following once

//variable dt is the Date type reference
DateFormat dtFormat = new SimpleDateFormat("dd-MM-yyyy");
String formattedDate=dtFormat.format(dt);

[Aditi agarwal]

thats only what we have used its not a new one

please tell me any difference in 1st & 2nd code you posted

thank you

[Swastik Dey]

In the first case a String which is in yyyy-mm-dd format, is first converted to Date object using the parse method, and then that Date object is formatted as String dd-mm-yyyy format using format method.

In the later case you already have a Date object, that is just formatted to the required format using format method.

[Aditi agarwal]

hey swastik i have used the following code

 while(rs.next())
  {
  DateFormat dtFormat = new SimpleDateFormat("dd-MM-yyyy");   
String formattedDate=dtFormat.format(rs.getDate("open_dt"));  
  

but still my date is in yyyy-mm-dd format no change please help

[Aditi agarwal]

thank you swastik its been solved i have just tried it once again & rectify my silly mistake

thank you