article
Daily charts got the viewer's time zone, and one route pasted it into SQL
The daily charts on my usage dashboard were bucketing days on the database's clock. The change that moved them onto the viewer's clock bound the zone safely in one place, spliced it into the query text in another, and left the range edges at UTC midnight.
Read more 4m read