Tech
Postgres AT TIME ZONE 'UTC' converts data type unexpectedly
Blog post details Postgres timezone conversion behavior
1
Sep 27 2:19 AM
· 2d ago · 1 post · 1 source · development 1 of 4
A technical blog post explains how Postgres's AT TIME ZONE 'UTC' command works—specifically that it converts the data type from timestamptz to plain timestamp rather than just changing representation. The author clarifies the distinction in response to confusion about the feature's behavior.
bookofrevenue.com
tanin47 Blog post author
The whole story the bright band is this development · numbered dots are the others · click one to jump
Peak 3 pieces in one hour at Sep 27, 1 AM; 28 pieces over 2 days (1 article · 5 posts · 22 comments)
Sep 27, 12 AM — 1 piece · 1 post — Reddit 1 Sep 27, 1 AM — 3 pieces · 3 comments — Reddit 3 Sep 27, 2 AM — quiet Sep 27, 3 AM — quiet Sep 27, 4 AM — quiet Sep 27, 5 AM — 2 pieces · 1 article · 1 post — Hacker News 1, Newswires 1 Sep 27, 6 AM — quiet Sep 27, 7 AM — quiet Sep 27, 8 AM — quiet Sep 27, 9 AM — quiet Sep 27, 10 AM — 1 piece · 1 comment — Reddit 1 Sep 27, 11 AM — quiet Sep 27, 12 PM — quiet Sep 27, 1 PM — quiet Sep 27, 2 PM — quiet Sep 27, 3 PM — quiet Sep 27, 4 PM — quiet Sep 27, 5 PM — quiet Sep 27, 6 PM — quiet Sep 27, 7 PM — 1 piece · 1 comment — Reddit 1 Sep 27, 8 PM — quiet Sep 27, 9 PM — quiet Sep 27, 10 PM — quiet Sep 27, 11 PM — quiet Yesterday, 12 AM — quiet Yesterday, 1 AM — quiet Yesterday, 2 AM — quiet Yesterday, 3 AM — 2 pieces · 2 posts — Mastodon 2 Yesterday, 4 AM — 2 pieces · 2 comments — Hacker News 2 Yesterday, 5 AM — 3 pieces · 3 comments — Hacker News 3 Yesterday, 6 AM — 2 pieces · 1 post · 1 comment — Hacker News 1, Mastodon 1 Yesterday, 7 AM — 1 piece · 1 comment — Hacker News 1 Yesterday, 8 AM — quiet Yesterday, 9 AM — 2 pieces · 2 comments — Hacker News 2 Yesterday, 10 AM — 1 piece · 1 comment — Hacker News 1 Yesterday, 11 AM — 1 piece · 1 comment — Hacker News 1 Yesterday, 12 PM — quiet Yesterday, 1 PM — 1 piece · 1 comment — Hacker News 1 Yesterday, 2 PM — quiet Yesterday, 3 PM — 2 pieces · 2 comments — Hacker News 2 Yesterday, 4 PM — quiet Yesterday, 5 PM — quiet Yesterday, 6 PM — 1 piece · 1 comment — Hacker News 1 Yesterday, 7 PM — quiet Yesterday, 8 PM — quiet Yesterday, 9 PM — quiet Yesterday, 10 PM — 2 pieces · 2 comments — Hacker News 2 Yesterday, 11 PM — quiet Today, 12 AM — quiet Today, 1 AM — quiet Today, 2 AM — quiet 1–2 3 4
yesterday now · 3:58 AM ET
All 4 developments of Postgres AT TIME ZONE 'UTC' converts data type unexpectedly →
