3 ms·
> A Valid Use Case For timestamp without time zone This should be "A Valid Use Case For timestamp with time zone". This article gets it all wrong. The only ti
by welder 8y ago
> A Valid Use Case For timestamp without time zone
This should be "A Valid Use Case For timestamp with time zone".
This article gets it all wrong. The only time it's acceptable to store time with time zone is DATES that do not have a TIME component.
- groestl 8y agoI'm probably just misunderstanding, but a calendar like Google Calendar definitely needs to store time with a time zone (i.e. dates with a time component). This allows to keep a scheduled event at 9 AM, even if the time zone offset is redefined (due to a political event).