Still run into schemas that use plain TIMESTAMP instead of TIMESTAMPTZ in Postgres and then wonder why scheduled jobs fire an hour off whenever Europe or the US shifts clocks. Storing UTC instants with TIMESTAMPTZ and converting at the display layer saves so many timezone bugs.
Commit
32bf56a
Storing timestamps without timezones is like storing "somewhere within this day" the worst way possible
Spot on. And the worst part is everything looks fine in tests until daylight saving transitions hit.
commit 32bf56a