Saving timestamps in Postgres based on Java dates

Question

I have a Postgres database with a table that contains a timestamp (timeOfProcessing TIMESTAMP).

I have a Java datetime value (java.util.Date dateTime) and want to store its value in that timestamp field (without time zone).

When I do it using the query

"INSERT INTO mytable(..., timeOfCreation, ...) VALUES(..., to_timestamp(" + Long.toString(dateTime.getTime()) + "),...)"

and then read the saved value (SELECT timeOfCreation FROM mytable), they are different (resultSet.getTimestamp(...).getTime() is not equal to dateTime.getTime()).

How do I need to change the insert statement in order for the datetime to be stored correctly?

Kalaji · Accepted Answer · 2013-08-08 17:37:18Z

21

When inserting, instead of using (dateTime).getTime(), use an SQL timestamp object: new java.sql.Timestamp((dateTime).getTime())

answered Aug 8, 2013 at 17:37

Kalaji

7567 silver badges10 bronze badges

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

1 Comment

Marcus Junius Brutus Over a year ago

@Sarief quite simply don't use an ORM. Embrace SQL and steer away from ORM monstrosities.

Collectives™ on Stack Overflow

Saving timestamps in Postgres based on Java dates

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related