im seeing a weird issue when inserting dates into postgresql…. i’m using clj-time to parse dates in the format yyyy-MM-dd and coerce to sql time…i print out that object and it appears correct (eg. 2018-01-02 ends up as #inst "2018-01-02T00:00:00.000000000-00:00"), however somewhere between clojure and postgresql the timezone ends up…elsewhere.

inserting that value manually using psql gives the right result

looks like the time ends up as 2018-01-01T05:00:00Z

What is the data type of the column in your DB @jgh?

date

Also, is your DB local or on another server? Are the timezones the same between your JVM/application and your PostgreSQL server?

im just running it locally, but see the same issues on the server

im in EST and just running it via docker on mac

clj-time is going to give you a UTC date/time so that is your problem.

the strange thing is i see this on the server that is in utc time too

You need the server on UTC and the JVM and the database -- those can be separate settings -- and the client app that is talking to the DB also needs to be in UTC.

is there a way of just forcing postgres to deal in UTC?

Timezones suck :):