Define a consistent day across timezones
Source: interviewintermediate
WHAT IT TESTS: consistent date bucketing across global timezones. OUTLINE: store events in UTC, capture the local/source timezone, then convert to a single reporting timezone at query time.
WHAT IT TESTS: whether you can make a daily metric reproducible and unambiguous across timezones. ANSWER OUTLINE: persist every event timestamp in UTC, store the originating timezone or offset (and ideally user/store locale), and decide on a single business reporting timezone for bucketing. At query time convert UTC to that reporting zone, then truncate to the day. Discuss DST and offsets that drift.
Read the original → interview
- #timezones
- #utc
- #data-modeling
- #reporting
- #date-handling
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.