how to insert datetime value into sqlserver dynamically

[krishnareddy]

I need to update datetime value into sql server2008 database table dynamically. I have created a date variable like


java.util.Date date=new java.util.Date();
java.sql.Date da=new java.sql.Date(date.getDate());

...
...
..
..some database code..
...
......
ResultSet rs..Some code..
/* I amsetting datetime value dynamically into database

rs.setDate(da);

it is updating currentdate but time set to 27-01-2012 00:00:00..so i could not getting current time..please help me inthis..how can i Set datetime value dynamically.

[Tolls]

Why are you updating via a result set?

Anyway, if this is a DATETIME field then use updateTimestamp().
Which of course begs the question...there isn't a setTime() method on ResultSet.

[HowardHyde]

PreparedStatement.setDate() takes a java.sql.Date as its argument, which truncates the time component. So you need to use PreparedStatement.setTimestamp(). Unfortunately, java.sql.Timestamp doesn’t take a java.util.Date in any constructor, so you have to take one extra step of getting the long millisecond value from your java.util.Date object via getTime() to pass to the java.sql.Timestamp constructor:
pStat.setTimestamp( 4, new java.sql.Timestamp(myDate.getTime()));
If anyone has a simpler, more streamlined solution than this, I have an open mind.

[krishnareddy]

HowardHyde,

Thanks for the reply..it is working..

[krishnareddy]

Sorry Tolls, I am using PreparedStatement obj to insert date into the table...

[HowardHyde]

HowardHyde,

Thanks for the reply..it is working..

You're welcome Krishna Reddy :)

[mkarthik90]

How about passing the date object of utility package as an argument to the constructor of sql.Date.

For example
java.util.Date today = new java.util.Date();
java.sql.Date sqlToday = new java.sql.Date(today.getTime());
ps.setString(1,sqlToday);

[Tolls]

If the column in the database is a DATE or DATETIME or TIMESTAMP (or whatever the particular name that flavour of database gives it), then you should use the proper setter or getter.
By using setString() you are foring Java to convert the Date to a String via toString, and then forcing the database to convert it back to a DATE (presuming the format is correct). If the format is incorrect (which is quite likely) you'll simply end up with an error from the DB.