Date Format Problem

[Pol Appan]

I have date which is in the format 2006-04-21 23:31:48.0

str_dt = 2006-04-21 23:31:48.0

When I used format_dt = inputFormat.parse(str_dt);

I am getting excpetion java.text.ParseException: Unparseable date: "2006-04-21 23:31:48.0"

How can I resolve this? I need to format my date and insert into oracle database with date and time.

Thanks in advance

[Christophe Verré]

You should set the proper format first:

SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
Date fDate = format.parse( "2006-04-21 23:31:48.2");
System.out.println(fDate);
Calendar cal = Calendar.getInstance();
cal.setTime(fDate);
System.out.println(cal);