On November 1, Your 24/7 Dashboard Will Report a 25-Hour Day

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.