Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> 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?



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.


They dont store original timezone




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: