Content
# #buellton — 2026-03-09
**11:54 [Mason Radke](https://slack.com/archives/C091185E1JN/p1773082458651569):** Investigated issue with SQL Query Configuration Historic Views returning incorrect daily totals twice per year due to DST clock changes. Root cause was the Calculation Base Time using a hard-coded UTC offset (`D-8H`) combined with UTC timezone setting, which did not account for Daylight Saving Time transitions. Resolved by changing the Timezone setting from UTC to Local Time (Use DST) and updating the Calculation Base Time to `D+8H` to preserve the intended 8:00 AM operational day boundary while allowing the system to automatically handle DST adjustments going forward.