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?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.