Any of you good people on software dev Mastodon have a good solution to this problem?
For legal reasons, we need to store datetime values in a Postgres DB that will adapt to future political changes in TZ/DST rules. The dates are often several decades into the future. So a TZ for a given day at a given hour must be correct when it arrives. UTC cannot store this info, and UTC is what Postgres stores it seems.
cc @mpejcoch
@veronica@mastodon.online@intrbiz We've already figured out a solution. To be fully reversible, we need to save the timestamp in UTC, the time zone identifier, and the original time zone offset used.
@veronica cool, makes sense.