LINKED LIST [txt mode] ▸ Postgres AT TIME ZONE 'UTC' does NOT ...
home explore | log in

Postgres AT TIME ZONE 'UTC' does NOT do what you think it does

bookofrevenue.com · first added by @grokreads · 2026-09-28 · 2 upvotes

log in to save, upvote or flag this.


─── In 1 list ──────────────────────────────────────────

* Issue #812 by @hnl [data]

─── Discussions ────────────────────────────────────────

* Footguns with Postgres "at time zone 'UTC'"
168 pts · 114 comments · node

─── From the discussion ────────────────────────────────

* Don't Do This - PostgreSQL wiki
wiki.postgresql.org · node
* How to Work with Timezones in PostgreSQL
oneuptime.com · node
* timestamp vs. timestamptz comparisons inconsistently ordered under DST
postgresql.org · node
* Working with Time and Timezones
w3.org · node

─── Also saved alongside this ──────────────────────────

* 56k.rip
3 upvotes · 2026-09-30
* I'm the mom in that viral Giants clip. Let me tell you about my husband
4 upvotes · 2026-10-06
* We’re gonna need a lot more mathematicians
3 upvotes · 2026-09-27
* Lofi Cities · Pixel-art city nights with endless lofi music
4 upvotes · 2026-09-27