On the last Sunday of October, most of Europe moves its clocks back one hour. On 25 October 2026, "today" in Berlin was 25 hours long. If you run business software, that is a good moment to ask a slightly uncomfortable question: do your reports know what day it is?
Mine once didn't. A daily sales report was a few orders short every morning, and those orders showed up in the previous day's total instead. Nothing was lost; it was just in the wrong bucket. It took longer than I'd like to admit to see the pattern: every "missing" order had been placed between midnight and 03:00 local time. The server ran in UTC, the business ran in UTC+3, and the report query asked the database for "today" in UTC.
This post is the set of rules I've used since then. None of them are clever.…