string convert in to Sql ate format

[reena Mehta]

i am trying to covert stringdate in to Sql date

stringDate is holding value 2008-03-19 19:44:58
#
# DateFormat formater = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
# java.util.Date parsedUtilDate = formater.parse(stringDate);
# java.sql.Date sqltDate= new java.sql.Date(parsedUtilDate.getTime());


output is: 2008-01-19
but i want same as 2008-03-19 19:44:58
please help me

Thanks
reena mehta

[Jesper de Jong]

What exactly do you mean with "output is: 2008-01-19"? Where do you see that; somewhere in the database, where you're looking at what's in the database with some program? Or are you just doing System.out.println(sqltDate);?

If you're doing the latter: Date objects (java.util.Date as well as java.sql.Date) do not remember what format they are in. When you want to show them in a specific format, you have to format them yourself using, for example, a SimpleDateFormat object.

System.out.println(formater.format(sqltDate));

[Sridhar Santhanakrishnan]

 java.sql.Date sqltDate= new java.sql.Date(parsedUtilDate.getTime()); 

The line above does what you want. You get Date object from the String. I think you are then printing the date which prints in the default "yyyy-MM-dd" format.

----- sigh beaten by a quicker and better explanation.

[Rob Spoor]

java.sql.Date doesn't care about its time part, just as java.sql.Time doesn't care about its date part. Use java.sql.Timestamp if you need both.

[Campbell Ritchie]

I think this discussion would sit better on our databases forum. Moving.