Re:Rob Pike's Rules of Programming (1989)
by Benjammer on Wednesday August 12, 2020 @05:50PM
(#24137418)
Totally. "Store everything in UTC" is just another flavor of "pick a timezone to store everything." In a lot of cases, you probably need to go ahead and just store the fully qualified date including timezone/offset for each record.
[ Parent
| on HN ]
Re:Rob Pike's Rules of Programming (1989)
by account42 on Thursday August 13, 2020 @04:44AM
(#24141218)
Even storing offset or timezone might not be enough if what you really want is some future date and time at a particular location. Timezones do change, including the regions they cover.
Still, for things that have already happended, storing them as a UTC timestmp is almost always the correct thing to do.