mrrubberburner

5 ms·

1. 1.▲
   by mrrubberburner 3y ago

   Timezonetz is explicitly designed for simplified arithmetic. By storing local values that have been converted to the utc constant, you get around the problem entirely. I think there must be some fundamental misunderstanding in these threads
2. 2.▲
   by mrrubberburner 3y ago

   Future events are trivially handled by timestamptz. PG takes your future timestamp and your client connections timezone converts to a utc constant and likewise casts the utc time to your timezone on reads.
3. 3.▲
   by mrrubberburner 3y ago

   If a user doesn't want to follow dst then they can say so and follow standard time by configuring their client connection. I’m struggling to think of a case where I would want an alarm clock setting or a dinner reservation to not be ad
4. 4.▲
   by mrrubberburner 3y ago

   Afaik Databases(as opposed to server) have a default timezone setting, but that is only used if the client hasn’t provided one.