| ▲ | arnitdo 2 days 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? | ||
| ▲ | piskov 2 days ago | parent | next [-] | |
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 2 days ago | parent | prev [-] | |
They dont store original timezone | ||