Comment by jasonl99

That is a phenomenal article about timezones in general that apply to any database, as well as a great explanation of features specific to postgres.

It is interesting that a timestamp without timezone is internally represented a timestamptz at UTC.

Postgres is also has some great functionality converting between timezones:

https://www.postgresql.org/docs/11/functions-datetime.html#F...