Yeah so you determine the offset at display time. Store “Europe/Amsterdam”, not “UTC+1” so that if Amsterdam (or likelier, the Netherlands) decides to shift timezone or move the DST change dates or something insane like that, before the event occurs, you can trivially take that into account by updating to the newest tzdata file.

Converting from timezone to offset is a lossy conversion.