How to store weekday and time with timezone?
We are currently storing events:
- As single dates
Date_from: 2022-11-11 10:00, Date_to: 2022-11-11 11:00) - As weekdays (Currently as one database entry)
Weekday: Monday, Time_from: 10:00, Time_to: 11:00
We want to add timezone information:
- Single dates: easy - just convert the datetime to UTC and convert it back when used
- Weekdays: ??
The questions:
- How do we handle different timezones with weekdays?
- Do we store the weekday in UTC? If so, how do we convert a weekday into an UTC weekday?