0

My table has a TIMESTAMP column. Per our convention all times in the db is supposed to be in 'UTC'. When I insert a java.util.Date it is converted using the JVM's default TimeZone. There seems to be no way to specify the TimeZone on session / connection level. Oracle JDBC supports this by calling oracleConnection.setSessionTimeZone("UTC");

Postgres JDBC seems to allow this by calling set timezone to 'UTC'; using the JDBC driver.

However, this does not have any effect. It is always the JVM's default time zone that determines how the conversion occurs.

The only solution I came up with is specifying a Calendar with UTC time zone when binding the java.util.Date to the PreparedStatement.

Improve this question
Related questions
859
How to make a datetime object aware (not naive)?
472
MySQL JDBC Driver 5.1.33 - Time Zone Issue
296
How to set time zone of a java.util.Date?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.