mrrubberburner
No user record in our sample, but mrrubberburner has activity below (stories or comments). Likely we have partial data — the full bulk-load will fill profiles in.
No user record in our sample, but mrrubberburner has activity below (stories or comments). Likely we have partial data — the full bulk-load will fill profiles in.
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…
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.
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…
Afaik Databases(as opposed to server) have a default timezone setting, but that is only used if the client hasn’t provided one.