3 ms·

So maybe individual stores can customize their opening time, but corporate still wishes to store a default. How do you represent the default? How do you handle

• bpfrh 3y ago
  I don't get your problem, couldn't you store it like this: table timetable: open | close | store 6am | 6am | default 7am | 12pm | store1 table stores: name | address store1 | xyx NYC If you can't find the store in the timetable: 1. Get the timezone of the target store by looking up the address from the table stores 2. Set Hours from the default row in the timetable table on the object with the timezone
• Izkata 3y ago
  > I'm trying to poke holes in the "always use UTC and you're good" advice. There's a much simpler one - recurring meetings/events (in-person or local-ish like within one country) that cross a DST boundary. You always want these to be attached to a local time zone, so it doesn't suddenly happen an hour earlier/later than you intended.
  • fragmede 3y ago
    Where that gets even more fun is with international meetings, where the host of the meeting and the attendees are in different zones.