Postgres 'at time zone' is confusing, but it's internally consistent. Once you understand what it's doing, you can work with it and it will reliably behave the way it's designed to.
-- TIMESTAMPTZ AT TIME ZONE 'X' -> returns TIMESTAMP in timezone X
-- TIMESTAMP AT TIME ZONE 'X' -> returns TIMESTAMPTZ treating input as timezone X
ForHackernews · · focus · HN ↗
<a href="https://oneuptime.com/blog/post/2026-01-25-postgresql-timezone-handling/view#converting-between-timezones" rel="nofollow">https://oneuptime.com/blog/post/2026-01-25-postgresql-timezo...