3 ms·
A Unix/NTFS/TAI timestamp would not be affected by the offset. Using Unix as the example: 2024-01-01T02:07:00+01:00_NO -> 1704071220_NO 2024-01-01T02:07:00+0
by Dylan16807 3y ago
A Unix/NTFS/TAI timestamp would not be affected by the offset. Using Unix as the example:
2024-01-01T02:07:00+01:00_NO -> 1704071220_NO
2024-01-01T02:07:00+01:15_NO-> 1704070320_NO
The timestamp doesn't have to be UTC, but it should specifically not be local time. You should be able to convert it to UTC without knowing the offset or time zone.
So, done this way, storing time zone and no offset is unambiguous. And it gives you more information than storing an offset and no time zone.
- magicalhippo 3y agoThanks, yes that makes sense. I was working under the assumption that ISO 8601 was meant to be human-readable. If you can forego that requirement, then the solution you present would work well indeed.