Maybe I'm missing something but it seems like much ado about nothing. Just use a timestamp — if you need to know the associated timezone, just store that as we

Maybe I'm missing something but it seems like much ado about nothing. Just use a timestamp — if you need to know the associated timezone, just store that as well. Done. But most often (when the timezone where the event was captured isn't relevant to the user or the business logic) conversion to local time is a frontend/view concern.