JDBC driver adjusts TIMESTAMPS (without zone) to the local time zone in ResultSets

When querying for TIMESTAMP or DATETIME values which are stored without a zone (ie, UTC), the JDBC driver constructs the resulting java.sql.Timestamp values WITH the local timezone set, which effectively alters the time that is retrieved from the time that was stored (when using a method like Timestamp.getTime() to get the time).

It's worth mentioning that other JDBC drivers, such as MySQL, will adjust TIMESTAMP values for the local timezone, but not DATETIME values. 

How can I get back a TIMESTAMP/DATETIME value from Vertica via JDBC that is exactly the same as what's in the database, not adjusted for timezone?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file