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
108db38
Storing timestamps without timezones is like storing "somewhere within this day" the worst way possible
commit 108db38
Spot on. And the worst part is everything looks fine in tests until daylight saving transitions hit.