I've run into this building various analytics systems. The off-by-45-minutes timezones mean that if you want to keep your data in UTC and translate to local tim

I've run into this building various analytics systems. The off-by-45-minutes timezones mean that if you want to keep your data in UTC and translate to local time in the UI, you have to maintain 15-minute granularity. (Although 30-minute or 1-hour granularity might be good enough depending on what users you need to initially support.)