How to convert Java Timestamp to mySQL datetime function

Question

My code uses Java.sql.Timestamp to store an update date. I want to take that date and store it into a mySQL datetime object. My problem is that the Java.util.Timestamp returns a date in the format of 2013-12-09 00:00:00.00 but the mySQL colunmn wants the format in 2013-12-09 00:00:00. So it looks like I need to trim off the .00 of the java.sql.Timestamp.

Jigar Joshi · Accepted Answer · 2013-12-09 17:32:41Z

1

You don't need to insert timestamp in mysql as String, just treat it as java.sql.Timestamp and use PreparedStatement to set the value properly

answered Dec 9, 2013 at 17:32

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alex Clark Over a year ago

I do just add the timestamp and it kicks this error com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'update_date' at row 1

Collectives™ on Stack Overflow

How to convert Java Timestamp to mySQL datetime function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related