Menu

The Report That Was Off by Three Hours: Timezone Rules for Laravel Business Apps
📰

The Report That Was Off by Three Hours: Timezone Rules for Laravel Business Apps

DEV Community: laravel·Tuğrul Yıldırım·16 days ago
#P0kgmDJk
#devtolaravel#devto#dev#timezone#date
Reading 0:00
15s threshold

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.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.