oh there’s also to-sql-date, maybe that’s what i need to use.

nope 😕

problem is there doesnt seem to be a timezone attached to the postgresql date type, just timestamp or time

Yup.

so i guess maybe it’s the jvm doing this?

what a pain

If you have everything on UTC, you're fine. Or else everything on Eastern time. As soon as you have pieces on different timezones, you're sunk.

let’s see what happens when we do :jvm-opts ["-Duser.timezone=UTC"]

that did the trick

why does jvm have its own timezone setting instead of using the machine it’s running on?

Like I say everything on UTC.

By default, the JVM will use the system timezone, but you can change it.

i see, i wonder why im seeing the same bug on my server…maybe cause im building the image in EST?

thanks for your help btw, i’ll just override everything to utc now.

Server has a TZ. Database has a TZ. JVM has a TZ. 🙂

alright, well that fixed it locally but my server is still screwed 😛

the server is UTC and I’m running the jar with the command java -Duser.timezone=UTC -jar service.jar

this might be a docker configuration issue thougg

hrm, nope 😕

ah it’s being stored right but not displayed right

momentjs helped 😛

@jgh this is another option at startup of your app:

;; using java.util.TimeZone
(TimeZone/setDefault (TimeZone/getTimeZone "UTC"))

I'm new to clojure so this may be a dumb question, but I keep getting this error when trying to query a database

java.lang.IllegalArgumentException: "sql-params" expected vector [sql param*], found clojure.lang.PersistentVector 

What am I doing wrong?