Hi, is anyone able to use pgsql with timezones properly? according to docs, OffsetDateTime should be available if java8 is running

https://jdbc.postgresql.org/documentation/head/8-date-time.html

but its not working for me

(->> (clojure.java.jdbc/query {:datasource datasource} "select '2018-08-31'::timestamp without time zone as t1, '2018-08-31'::timestamp with time zone as t2;")
     first
     vals
     (map #(.getTimezoneOffset %)))
=> (-60 -60)

I don’t have direct answer but this helped me when I was confused http://blog.untrod.com/2016/08/actually-understanding-timezones-in-postgresql.html

tks @valtteri I think jdbc is always converting to local time

and that blog helped

@mping Recommendation: always run your production infrastructure on UTC -- configure your O/S, your database, and your JVM for all processes to be UTC, with the servers set to NTP sync. It'll save a lot of complications. Timezones are hard.