There are few things developers love more than having to handle timezones. One of them is having to handle timezones in different environments!

Lately I had to deal with some timezone operations across Python and Postgres and decided to document here the shenanigans and quirks of the two systems and how I try to avoid them.

TIMESTAMP WITH TIME ZONE does NOT store a timezone

This is something I knew already but it irks me every time I remember it exists.