Post reaches Hacker News frontpage
3 Sep 27 6:19 AM · 1d ago · 1 article · 1 post · 1 comment · 3 sources · development 3 of 4
The article circulates on Hacker News under the headline 'Footguns with Postgres "at time zone 'UTC'"', generating discussion among database engineers.
“I wish we'd just collectively start using IANA time zones as a default. Conversion and arithmetic are solved problems for them, and it's the least ambiguous format for stored dates.”
FuckOnion, Reddit commenter · reddit ↗tanin47 Blog post author
The whole story articlespostscomments the bright band is this development · numbered dots are the others · click one to jump
What was reported 1 claim about this development
-
first by HN Frontpage, 1d ago
What people said 1 voice · verbatim
-
I wish we'd just collectively start using IANA time zones as a default. Conversion and arithmetic are solved problems for them, and it's the least ambiguous format for stored dates. Offsets are ephemeral whereas IANA time zones are built to last.
All 4 developments of Postgres AT TIME ZONE 'UTC' converts data type unexpectedly →
RedditHacker NewsMastodonNewswires