Fighting a 30-year-old software bug

http://blogs.perl.org/users/ovid/2013/10/fighting-20-year-old-software-bugs.html

by levosmetalo • 13 years ago

78 12 13 years ago

blogs.perl.org

ttflee2• 13 years ago

Sometimes I feel guilty for not insisting to use 64-bit time stamp for company's products. Hope anyone keeping those gadgets long enough to hit year 2038 would get sufficient fortune.

apaprocki2• 13 years ago

Related anecdote: Interestingly enough, Excel doesn't support dates prior to the "Excel epoch". I had some genealogical spreadsheets that I had to move to Google Docs from Excel because Docs supports arbitrary years and Excel treats anything prior than 1900 as strings instead of dates, losing the ability to perform date/time operations.

ttflee2• 13 years ago

I guess those dates must be treated with greater caution, as the history and calendar used to be complicated(, not as smooth as UTC time).

http://www.quirksmode.org/blog/archives/2009/04/making_time_...

apaprocki2• 13 years ago

Sure, but I'm mainly talking about using a spreadsheet just as a spreadsheet. If you enter a bunch of mixed pre-/post-1900 dates into a column and then change the formatting to display as "DD-Mon-YYYY" everything will change except the pre- dates. There isn't really anything complicated needed to make that work, implementation-wise.

xntrk• 13 years ago

How old is the bug? The url says 20 the link and header both say 30.

agrona• 13 years ago

FTA

Er, an earlier version of this said the software bug was 20 years old. It's 30! Thanks, Sidhekin

eCa• 13 years ago

Lotus 1-2-3, the cause of the bug/feature, was released in 1983 [1].

[1] http://en.wikipedia.org/wiki/Lotus_1-2-3

Ovid• 13 years ago

Yeah, I'm the author of that post and I elected not to change the link after I changed the title. I love the irony of me originally making a date math error in the title when the bug was about date math :)

curveship• 13 years ago

Given Excel's popularity in the business world, I wonder if an exploit of some sort could be built into scheduling a transaction for February 29th, 1900. The date exists in Excel, but not the real world.

finnh• 13 years ago

Classic example of why greenfield development is much more pleasant than dealing with legacy systems. Of course, you have to do your new dev well to prevent it from becoming a legacy system that you have to fight with...

But I do think the world of development is just soooo much better now that it was 10 or 20 years ago. We, as a profession, have much to be thankful for.

patmcguire• 13 years ago

My first thought was, "I remember this. Blame Joel Spolsky:" http://www.joelonsoftware.com/items/2006/06/16.html (well maybe not blame, it's a tradeoff.)

But he mentions it at the end.

oaktowner• 13 years ago

Nice call! I was coming in to post that link, but I see you beat me to the punch.

Fighting a 30-year-old software bug

Related Stories