How do I convert a Java TimeStamp object to a SQL datetime type that includes milliseconds? When I insert my TimeStamp obj into the database the milliseconds are gone.
This is my Java source code to translate a String into a Timestamp object:
import java.sql.Timestamp;
...
...
String timeStr = "2013-08-30 19:11:49.113";
Timestamp timeCreated = Timestamp.valueOf(timeStr);
timeCreated.toString(); //returns "2013-08-30 19:11:49.113"
My table dfinition in SQL:
CREATE TABLE `Event` (EventTimeStamp datetime NOT NULL);
This is how I insert the TimeStamp object into my Database:
PreparedStatement psInsert;
Connection conn = ...
psInsert = conn
.prepareStatement("INSERT INTO `Event` (EventTimeStamp) VALUES(?)");
psInsert.setTimestamp(1, timeCreated);
psInsert.executeUpdate();
After insertion the TimeStamp is cut and there are no milliseconds anymore:
2013-08-30 19:11:49
Thx
SELECT * FROM Event;