This is a good article, it's worth reading in full. It touches on the different use cases for different types of time/date storage but doesn't make it explicit enough that the is no "one size fits all" solution. It's true that internally a TIA timestamp is cleaner for storing a moment in time, but that is only half the issue. I like to think of it as a difference between physical time and human time. For engineering,…
> I think we need something like this: > 2022-11-23T08:52:02!Europe/London There is a IETF standard proposal, which is very closed to getting finalised, that defines a similar format: 2022-11-23T08:52:02+01:00[Europe/London] ref: https://datatracker.ietf.org/doc/draft-ietf-sedate-datetime-... It's already in use by the Temporal TC39 proposal, which defines new types for working with temporal data in JavaScript. ref:…
For more fun, what does 2024-11-23T08:52:02+00:00[Europe/London] mean now, and what does it mean if the UK switches to a +1 hour offset all year round in 2023?
If i understand the proposal correctly, the actual moment in time represented by one of these is given by the time and the offset. The bit in square brackets is just metadata. The spec says:
> This document does not address extensions to the format where the semantic result is no longer a fixed timestamp that is referenced to a (past or future) UTC time.
But that result is precisely why we need this!