Temporal: Getting started with JavaScript's new date time API

Re:Temporal: Getting started with JavaScript's new date time... by nicoburns on Monday June 28, 2021 @06:23PM (#27669040)

Yep! It sounds like overkill, but the suggestion I've seen that seemed to cover all bases was to store:

(1) The time in the local timezone (+ the timezone itself) (2) The UTC conversion (3) The version of the IANA database used to compute (2)

Then you can use (2) the UTC time for most computations/queries, but if a timezone changes then you can use (3) to tell which UTC dates need to be updated, and (1) to recompute the new correct version of (2).

[ Parent | on HN ]

Re:Temporal: Getting started with JavaScript's new date time... by mattmanser on Monday June 28, 2021 @06:34PM (#27669153)

That seems like overkill for most apps. Better to just store the date/time without timezone, and either the windows or linux timezone name of the location (which has far more specificity than the ISO 8601 offset). Then calculate the actual time on the fly when pulling it out of the DB.

No mucking around with IANA databases, everything's easy to program, server usually keeps itself up-to-date.

[ Parent | on HN ]