Nelson's Weblog: tech / daylight-savings-and-you

Daylight Savings Time vs. your server

How many hours are there in a day? Twenty-four of course, except for the couple of days a year when there's 23 or 25. Worse, which days have odd hours changes every year, is unpredictable, and is subject to the whim of local politicians, religious leaders, and sporting events. This fall's DST change happens at 50 different times depending on your location. It's a terrible way to keep time.

Daylight Savings Time is confusing enough for people but it plays hell with software. There's an Internet advertising company I'm intimately familiar with that used to lose significant money twice a year because of customer budget algorithms that assumed every day had 24 hours. Once a year customers would only spend 23/24 of their budget losing 4% revenue, and once a year they'd spend 25/24 of their budget requiring 4% refunds. Now fixed, I'm pretty sure, but fixing it isn't easy if you're calculating in local time.

The solution for software is simple; do all calculations in Coordinated Universal Time. UTC doesn't do daylight savings, so every day has 24 hours. (Technically some days can be a second too long or short, but for most applications that error is small enough to be ignorable.) The easiest way to be sure you're doing UTC everywhere is to set your servers' timezones to UTC. You'll forever be confused when looking at log files, particularly since your own offset to UTC is changing with daylight savings, but with a desktop clock showing UTC you can usually puzzle it out.

tech
2009-10-28 15:51 Z


Mastodon @nelson@tech.lgbt Linkblog Wed 2024-11-20 Francis Williams painting The Platonic Blow Tue 2024-11-19 EmojiRain Bantam Tools Artframe Using OSM vector tiles Starlink sold out Fine-tuning LLMs at home Bluesky starter packs Mon 2024-11-18 Carbon Mapper Sun 2024-11-17 Love, Acceptance, and Screeching Modems Voyager 1 backup radio Gay Tblisi Usenet feed growth Methane mapping City99 console font Sat 2024-11-16 Lorraine Gervais Sill Justin's Linklog Thune 2004 blog campaign Fri 2024-11-15 Open source garage door Search Archives 2023 12 11 10 09 08 07 06 05 04 03 02 01 2022 12 11 10 09 08 07 06 05 04 03 02 01 2021 12 11 10 09 08 07 06 05 04 03 02 01 2020 12 11 10 09 08 07 06 05 04 03 02 01 2019 12 11 10 09 08 07 06 05 04 03 02 01 2018 12 11 10 09 08 07 06 05 04 03 02 01 2017 12 11 10 09 08 07 06 05 04 03 02 01 2016 12 11 10 09 08 07 06 05 04 03 02 01 2015 12 11 10 09 08 07 06 05 04 03 02 01 2014 12 11 10 09 08 07 06 05 04 03 02 01 2013 12 11 10 09 08 07 06 05 04 03 02 01 2012 12 11 10 09 08 07 06 05 04 03 02 01 2011 12 11 10 09 08 07 06 05 04 03 02 01 2010 12 11 10 09 08 07 06 05 04 03 02 01 2009 12 11 10 09 08 07 06 05 04 03 02 01 2008 12 11 10 09 08 07 06 05 04 03 02 01 2007 12 11 10 09 08 07 06 05 04 03 02 01 2006 12 11 10 09 08 07 06 05 04 03 02 01 2005 12 11 10 09 08 07 06 05 04 03 02 01 2004 12 11 10 09 08 07 06 05 04 03 02 01 2003 12 11 10 09 08 07 06 05 04 03 02 01 2002 12 11 10 09 08 07 06 05 04 03 02 01 2001 12 11 10 09 08 07 One good site MDN Nelson Minar nelson@monkey.org Blog licensed under a Creative Commons License		Daylight Savings Time vs. your server How many hours are there in a day? Twenty-four of course, except for the couple of days a year when there's 23 or 25. Worse, which days have odd hours changes every year, is unpredictable, and is subject to the whim of local politicians, religious leaders, and sporting events. This fall's DST change happens at 50 different times depending on your location. It's a terrible way to keep time. Daylight Savings Time is confusing enough for people but it plays hell with software. There's an Internet advertising company I'm intimately familiar with that used to lose significant money twice a year because of customer budget algorithms that assumed every day had 24 hours. Once a year customers would only spend 23/24 of their budget losing 4% revenue, and once a year they'd spend 25/24 of their budget requiring 4% refunds. Now fixed, I'm pretty sure, but fixing it isn't easy if you're calculating in local time. The solution for software is simple; do all calculations in Coordinated Universal Time. UTC doesn't do daylight savings, so every day has 24 hours. (Technically some days can be a second too long or short, but for most applications that error is small enough to be ignorable.) The easiest way to be sure you're doing UTC everywhere is to set your servers' timezones to UTC. You'll forever be confused when looking at log files, particularly since your own offset to UTC is changing with daylight savings, but with a desktop clock showing UTC you can usually puzzle it out. tech 2009-10-28 15:51 Z Nelson's Weblog • tech → ago, bad, bittorrent, blosxom, dotnet, good, hqnx, iphone, mac, phone, photo, python, webservices