Trouble when inserting time and date to db using Java

Question

Here's my code:

    uprs.moveToInsertRow();
uprs.updateString("Sender", myName);
uprs.updateString("Receiver", withWho);
uprs.updateString("Message", myMessage);
//uprs.updateString("Time",****);
uprs.insertRow();

Things go perfectly when adding the non-time data into the database.

But I am struggling how to add the current date and time into the database.(Ms SQL 2008)

Is there any expert can tell me how to organize the code about getting the current time and date and insert them into the db?

The data type of Time in my db is "datetime".

Thank you!

beny23 · Accepted Answer · 2012-03-31 15:00:30Z

1

For a date/time type you should use updateTimestamp instead of updateString

answered Mar 31, 2012 at 15:00

beny23

35.1k6 gold badges84 silver badges86 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Trouble when inserting time and date to db using Java

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related