You don’t need to store timestamps “in UTC”. You just need to store the time zone offset. That extra few bytes of precision representing where the timestamp sender is makes the sun location absolute.
Some databases let you input values like “2022-03-13T08:33:26-06:00” and then display them in UTC or your local time zone or whatever time zone you configured. BugQuery at one time was toying with the idea of taking a few additional bytes of information to represent the preferred display timezone of the timestamp, but I have no idea if that ever made it to beta.