‹ BackHN Continuity

Thread

Footguns with Postgres “at time zone 'UTC'”

169 points · 114 comments · birdculture

  1. paulddraper · · focus · HN ↗
    TLDR Always use timestamptz (timestamp with time zone).

    Only use timestamp (timestamp without time zone) if you really need local/plain datetime.

    (Ideally, timestamptz would be called timestamp/instant, and timestamp would be called datetime.)

Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.