Not able to convert string to date

[Kartik Tal]

Hi all,

I want to convert a string to Date in the format of "19/Apr/2010 17:46:57". Below is my code but this is not changing its giving in the format of "Mon Apr 19 17:54:39 GMT+05:30 2010"

   
DateFormat dateFormat = new SimpleDateFormat("dd/MMM/yyyy HH:mm:ss");
Date date=new Date();
String s="";

    s=dateFormat.format(date);
    date=dateFormat.parse(s);
    System.out.println("Date>>>"+date);

[Henry Wong]

A Date object doesn't have a changeable format. If you want to print the date object in a particular format, you will have to format it and print the resultant string -- formatting the date to a string, and parsing it back to a date, doesn't really do anything.

Henry

[Doug Braidwood]

A Date doesn't have a format, it's a number representing milliseconds.

Do you want to display it in the format "dd/MMM/yyyy HH:mm:ss"?

What do you get if you output System.out.println(s) after line 6?

[Kartik Tal]

Doug,
after 6th line am getting the same format i needed but its in string only "19/Apr/2010 17:46:57".
While am inserting that string into database Oracle its giving an exception as "date format picture ends before converting entire input string".


Regards,
Kartik

[Doug Braidwood]

Are you specifying a format when you insert into Oracle? Does that format on the Oracle insert match the String? It sounds like it might be missing a bit..

[Kartik Tal]

From oracle also i inserted in this way

insert into student values('1','19/Apr/2010 17:24:59').

its giving the same error as "date format picture ends before converting entire input string"

[Doug Braidwood]

I think that what's happening there is that the format of your date string is not the format that Oracle is expecting.

if you try something like this:

insert into student values('1',TO_DATE('19/Apr/2010 17:24:59','DD/MON/YYYY HH24:MI:SS''))

then you are telling Oracle exactly what format date string is in and it should work.

Does that help?

[Rob Spoor]

Switch to PreparedStatement:

PreparedStatement statement = connection.prepareStatement("insert into student values(?,?");
statement.setInt(1, 1);
statement.setTimestamp(2, new Timestamp(System.currentTimeMillis());
// or, using any Date object
//statement.setTimestamp(2, new Timestamp(date.getTime());

This problem is evidently an Oracle problem so I'm moving this to our JDBC forum.

[Kartik Tal]

thanks doug it worked for me....

[Doug Braidwood]

My pleasure