‹ BackHN Continuity

Thread

Footguns with Postgres “at time zone 'UTC'”

169 points · 114 comments · birdculture

  1. derefr · · focus · HN ↗
    > '2026-02-28 16:00:00-08'::timestamptz AT TIME ZONE 'UTC'

    Er… just write '2026-02-28 16:00:00-08Z'::timestamptz.

Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.