The other day at work I stumbled upon this bug and thought it was worth to write a blog post about. Spoiler: It has nothing to do with timezones!
TLDR: According to ISO standard 8601 (which is what Python's date.isocalendar().week uses for example), the first week of the year is the week with the first Thursday of the year. So sometimes the first few days of January belong to the last week of previous year, and sometimes the last few days of December belong to the first week of next year :D
42 Comments
litchralee@sh.itjust.works · 39 pts · 151d
Obligatory links:
Falsehoods that programmers think about dates and times: https://infiniteundo.com/post/25326999628/falsehoods-programmers-believe-about-time
Tom Scott descends into time and timezone madness: https://www.youtube.com/watch?v=-5wpm-gesOY
I've personally never worked with ISO 8601 directly, and quite frankly prefer how RFC 3339 simply doesn't deal with weeks at all.
null4141@programming.dev · 7 pts · 151d
That video is a classic. It's exactly why I put "it has nothing to do with timezones" as subtitle for the post :) That was my first guess when I encountered the bug, before I realized it was about the ISO weeks.
And in the end of the post I also added a list of falsehoods, different from your link tho: https://gist.github.com/timvisee/fcda9bbdff88d45cc9061606b4b923ca
Skullgrid@lemmy.world · 29 pts · 151d
fuck sake.
thanks for the heads up
Pissmidget@lemmy.world · 21 pts · 151d
Week numbers can also vary by country. Not always, but sometimes, as we're not all in agreement on what constitutes the first week of the year.
Something most people in international organisations and teams get to find out the hard way at least once.
bleistift2@sopuli.xyz · 17 pts · 151d
If you think looking at Thursday seems like a random choice: It’s basically a majority vote among the days of the week. If Thursday is in the new year, then 4 days (Thu–Sun) are in the new year. If Thursday is in the old year, then 4 days are in the old year (Mon–Thu).
ttayh@lemmy.zip · 17 pts · 151d
The 1st day of the feek is not universal. I grew up with the week starting on sunday
bleistift2@sopuli.xyz · 16 pts · 151d
Yes, another thing in the neverending list of shit you have to learn at some point if you’re any kind of programmer.
Some people start their week on the wrong day.
sergiu@lemmy.world · 8 pts · 151d
Is this a thing outside the USA? It always bugs me when apps default to this. How does it make any sense for the week to start with the weekend?
brisk@aussie.zone · 9 pts · 151d
A string has two ends
sergiu@lemmy.world · 5 pts · 151d
A string is reversible, a week is not. A week has a beginning and an end.
technohacker@programming.dev · 3 pts · 151d
I've generally seen Sunday to be the start of the week here, my current headcanon for it is that Sunday and Saturday sort of book-end on both sides of the week, hence week-end_s_ plural
sergiu@lemmy.world · 2 pts · 151d
I'm just curious how this works in practice.
When you say something like "Let's meet up this weekend", is it implied that you will meet on Saturday, since Sunday is the other end of next week, so technically a different weekend?
technohacker@programming.dev · 2 pts · 151d
Not quite sure actually, I think we end up specifying a day or implicitly consider both of them
agamemnonymous@sh.itjust.works · 1 pts · 150d
Honestly I think of Friday night and Saturday. Sunday feels more like its own thing,the beginning of the week. It's the day you do any unfinished chores to prepare for the week. If sometime wanted to "meet up this weekend" I would not assume they meant Sunday, unless they wanted to grab brunch.
locuester@lemmy.zip · 1 pts · 150d
The weekend, and more specifically “this weekend” or “this coming weekend” means both days - Saturday and Sunday.
Sunday being a part of next week on a written calendar does not even register as a potential date “problem” with my brain in day-to-day talk.
emergencyfood@sh.itjust.works · 2 pts · 150d
Yes, most of Asia starts weeks on Sundays.
bleistift2@sopuli.xyz · 2 pts · 151d
God rested on the seventh day, but Sabbath is on Saturday. Tadaa, week starts on Sunday.
sukhmel@programming.dev · 1 pts · 150d
Yeah, so do we need to make Sunday a work day, too?
folekaule@lemmy.world · 16 pts · 151d
Even better: two weeks with the same week number can exist in the same year.
SleeplessCityLights@programming.dev · 8 pts · 151d
Fuck, I just wrote an app to help HR process data and I had to, without using Ai, define the first week of the year to match that ISO spec. Week 53 was a fun one but I now have to cover two weeks with the same number.
folekaule@lemmy.world · 12 pts · 151d
Yep, but the year of week will be different for each.
Use a date library. Life is too short to make your own. The new Temporal library in JavaScript is quite good.
SleeplessCityLights@programming.dev · 9 pts · 151d
It's written in C++ lol
Valmond@lemmy.dbzer0.com · 3 pts · 150d
As all good libraries are 😎
bleistift2@sopuli.xyz · 3 pts · 150d
Sadly, Safari fucks us yet again.
sukhmel@programming.dev · 2 pts · 150d
What is it this time?
bleistift2@sopuli.xyz · 2 pts · 149d
Well, Safari is the only browser not to support the new Temporal API.
sukhmel@programming.dev · 2 pts · 149d
Ah, I thought they actively broke it somehow
hallettj@leminal.space · 5 pts · 151d
How is that? Do you mean that week 1 can occur twice? Or is there another issue?
IIUC you can have days at the start and the end of the year that are all in week 1, and those are two different weeks. But one of those would be, let's say, week 1 year 2025, and the other would be week 1 year 2026. According to the blog post if you have a week 1 at the end of a year the ISO year number for that week is the next year.
folekaule@lemmy.world · 15 pts · 151d
It only happens with ISO weeks. An example is 2006. Each of the weeks belong to different years (so 2005W52 and 2006W52 are different), but each can contain days from another year. So for example Sunday 2006-01-01 is part of week 52 of 2005. Week 1 starts on January 2. Then at the end of 2006 you have another week 52, but that week is actually part of 2006.
It's a bit of a cheeky thing to point out, because at no point is a day in two different weeks, and the week itself only belongs to one year. It's just that you can't assume that any given day belongs to the same year as the week it is in. That is: 2006-01-01 is in 2005W52 not 2006W01.
null4141@programming.dev · 4 pts · 151d
This is basically the takeaway from my blog post, if you're going to use weeks, use the ISO year instead of the calendar year :)
NotMyOldRedditName@lemmy.world · 12 pts · 150d
I hate working with date/time.
NotMyOldRedditName@lemmy.world · 5 pts · 150d
I kid you not, i just had to fix a date time issue around formatting lol. Like minutes after I wrote i hate it lol.
Slashme@lemmy.world · 4 pts · 150d
Similarly, developers have many misconceptions about addresses: https://www.mjt.me.uk/posts/falsehoods-programmers-believe-about-addresses/
zerofk@lemmy.zip · 4 pts · 150d
When we implemented week numbers we actually had to support both systems because customers expected the number to match that in their other applications - some of which followed the standard, and some didn’t.
Semi_Hemi_Demigod@lemmy.world · 3 pts · 151d
Valmond@lemmy.dbzer0.com · 2 pts · 150d
So nobody talks about leap seconds? 😅
csolisr@hub.azkware.net · 1 pts · 151d
Did they settle for Thursday as the "middle of the week" specifically because ISO 8601 starts the week count on Mondays?
spartanatreyu@programming.dev · -1 pts · 151d
Also: January is not always the 1st month, sometimes it is the 0th.
1/1/2026 can be both Jan 1st, and Feb 1st.
For the downvoters, try it in your browser's terminal:
locuester@lemmy.zip · 2 pts · 150d
U mean “the months are zero indexed” and “the first month is 0”
spartanatreyu@programming.dev · 0 pts · 150d
The first month is inputted with a 1 and exported as a 0.
The first day is inputted with a 1 and exported as a 1.
locuester@lemmy.zip · 2 pts · 150d
I understand that. Because the months are zero indexed. But it’s not just the first month that’s “0-indexed”. The list of months is zero indexed. Perhaps I’m arguing semantics - but was simply adding clarity for the reader.
1st becomes 0, 2nd becomes 1, 3rd becomes 2
sukhmel@programming.dev · 1 pts · 150d
Yeah, but when days are 1-indexed and month are 0-indexed you just feel it's a very JavaScript thing to do
locuester@lemmy.zip · 2 pts · 150d
Yeah absolutely. I’m not disagreeing or saying it’s good.
I’m just correcting the strange wording.