[arnitdo]

> And don’t get me started with storing datetime with timezone (e.g “4/2/2007 7:23:57 PM -07:00“). In sql server you have datetimeoffset; in Postgres you fuck off :-)

`TIMESTAMPTZ` / `TIMESTAMP WITH TIME ZONE` exists?

[piskov]

I don’t know who was the genius who invented that but timestamp *with time zone* doesn’t store the time zone.

Timestamp with time zone actually means gmt time created from a time zone which is then discarded because fuck you that’s why.

[nopurpose]

They dont store original timezone