This story was originally published on HackerNoon at:
https://hackernoon.com/on-november-1-your-247-dashboard-will-report-a-25-hour-day.
Malek Damiri on why 24/7 dashboards report a 25-hour day when clocks fall back on Nov 1, and a calendar-table SQL fix for DST.
Check more stories related to data-science at:
https://hackernoon.com/c/data-science.
You can also check exclusive content about
#data-analytics,
#sql,
#daylight-saving-time,
#time-zones,
#business-intelligence,
#data-engineering,
#crypto,
#dashboards, and more.
This story was written by:
@malekdamiri. Learn more about this writer by checking
@malekdamiri's about page,
and for more stories, please visit
hackernoon.com.
Any business that runs around the clock but reports by local calendar day gets a 25-hour day when clocks fall back (November 1 in the US, October 25 in Europe) and a 23-hour day in March. Revenue operations lead Malek Damiri shows the 4% phantom swing it creates, three bugs that make it worse, and a calendar table with hours_in_day that fixes it, using runnable DuckDB and Snowflake SQL.