Footguns with Postgres "at time zone 'UTC'"
An article on Hacker News examines common mistakes when using PostgreSQL’s AT TIME ZONE 'UTC' clause. It explains how the function behaves differently with timestamp without time zone versus timestamp with time zone, leading to off‑by‑hour errors. The piece offers examples, clarifies the underlying conversion rules, and suggests safer alternatives for handling UTC timestamps in queries.