12 ms·
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 inte
by jasonl99 8y ago
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#FUNCTIONS-DATETIME-ZONECONVERT https://www.postgresql.org/docs/11/functions-datetime.html#F...