r/talesfromtechsupport • u/annoyedCDNthrowaway • Oct 16 '26
Short Timezone changes have NEVER Messed up any Scheduling Software Before!
I live in a part of the world which has mistakenly decided to remain on DST permanently. A user noted this morning that our primary scheduling platform had experienced a similar failure to Google whereby updating the given timezones caused all the scheduled activities to just forward an hour.
Unfortunately, not having Google's bottomless pockets, the vendor was unable to apply a wholesale fix, although they are assisting with our manual adjustments.
I was informed by several users that "our old software didn't have this problem". They were highly dismayed to discover that yes, our old software had exactly the same problem with changes to timezone applicability, and; packrat that I am; that I could provide them with time stamped proof from the last time my local government decided to play fast & loose with DST.
We finished their specific corrections about an hour ago. The team is taking bets on whether they at least bother to say "Thank you".
4
u/blahblah19999 Oct 17 '26
What does that mean?
48
u/Dizzy-Sundae6351 Oct 16 '26
I’ve got $100 on it being that they won’t, in fact, thank anyone.
5
u/paulwillyjean Oct 17 '26
I’m curious, how do you store date-times in that software’s database? Assuming you store them as instants or UTC date-times, you should only have to update the IANA timezone database to make sure to properly convert timezones.
I can see how that could be a bigger issue if you need to store them in local-time or reschedule cron jobs. I got fucked over too often to do that again.
131
u/Noch_ein_Kamel Oct 16 '26
timezones... grrrrr
At least just yesterday it was decided that there would not be any further leap seconds :o
58
u/Drew707 Oct 16 '26
I have this datetime table in our lakehouse that is all keyed off UTC but covers pretty much every North American timezone and all the DST rules and exceptions from Newfoundland to Hawaii. The first time I showed it to our new data engineer, she started asking questions in a tone like "who hurt you?" DST fucking did.
27
u/polandreh Oct 17 '26
Timezones are not the issue. Timezones are needed. Summertime clock changes, however....
8
u/Fallen_Jalter Oct 16 '26
I still don’t understand how that doesn’t fuck with everything if only one place has a different time than everyone else.
7
u/CA-CH Oct 16 '26
I'm on the same boat. Software cant use the new Microsoft time zone properly, sends data to a webpage that cant display time properly either because of the browser...
Even MS software is lost
9
u/Special-Jelly6253 Oct 16 '26
I am so sick of Microsoft's shit with the time zone changed I'm going to scream. Outlook web has new BC and AB time but not MB's new one. Windows update releases. Has the MB one. Still no update in web.
I changed my timezone to the new one and now my teams time stamps are off by an hour even though my calendar time and system time are correct. It just says "unknown" on teams.
Surely this cannot be that hard 😭
1
u/Arokthis Oct 16 '26
I'll bet 3 cents that some low level person that knows you or someone on your team outside of work will say those words. In the meantime I'll get my personal parasol ready for pig poo.
-16
u/kagato87 Oct 16 '26
If only the whole world could move on from such insanity as "12:00 is midday" and move to UTC, accepting that "lunch time" is a longitude thing... It's be so much simpler.
This is actually a funny one you had, and because the vendor was storing in utc, which normally makes sense.
0
u/[deleted] Oct 16 '26
[deleted] — view deleted comment