3 ms·
> 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 o
by arnitdo 6mo ago
> 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?
- nopurpose 6mo agoThey dont store original timezone
- piskov 6mo agoI 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.