This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2023-01-31
Channels
- # announcements (22)
- # asami (19)
- # aws-lambda (4)
- # babashka (42)
- # beginners (43)
- # calva (28)
- # cider (1)
- # clerk (79)
- # clj-kondo (12)
- # clojure (47)
- # clojure-berlin (1)
- # clojure-brasil (1)
- # clojure-dev (12)
- # clojure-europe (40)
- # clojure-nl (2)
- # clojure-norway (5)
- # clojure-uk (3)
- # clojurescript (56)
- # clr (12)
- # conjure (8)
- # cursive (4)
- # datomic (78)
- # dev-tooling (6)
- # exercism (1)
- # fulcro (9)
- # hoplon (3)
- # jobs (3)
- # jobs-discuss (4)
- # lambdaisland (3)
- # leiningen (1)
- # london-clojurians (1)
- # lsp (125)
- # malli (32)
- # matcher-combinators (3)
- # nrepl (1)
- # off-topic (6)
- # pathom (39)
- # re-frame (13)
- # releases (2)
- # remote-jobs (3)
- # sci (7)
- # shadow-cljs (117)
- # sql (6)
- # squint (7)
- # tools-build (15)
- # tools-deps (12)
Hi guys! Postgresql question. I have a table with date timestamp
fields. I use next-jdbc
and honeysql
to deal with postgres (wonderfull libs by the way). I use next.jdbc.date-time
to convert java.time.Instant
date. When I insert a date with (instant/now)
, I get a utc date when I query the table in clojure. When I use the psql
cli and do a select my_date_field
, the date is displayed with a one extra hour (like my current local date).
I check the show timezone
and it’s on Etc/UCT
. What param I miss to display the real date in psql?
Where are you running psql
compared to where your Clojure code is running?
Everything needs to be set to UTC to avoid timezone/daylight-savings shifts.