John Carmack may have misremembered the 10th digit of pi, but you should all search your codebases for 84,600 and see who typo'd the number of seconds in a day. It is surprisingly common and there is a lesson about whether or not you should type constants into your program when they likely exist in the standard library of your programming language.
None of those look fatal but I think they all differ from the intent of the author. That's why code review is so good. You just need someone to ask "what's 874600?". Turns out: not a thing.
MySQL's issue is a timeout on SSL sessions which is normally 300s. Textmate's is a "friendly" display of the time. Not a showstopper, but probably not what they had in mind. It's so easy to transpose digits. It's great to have someone ask "are you sure?".
I spent an embarrassing amount of time debugging why some token refresh code that was supposed to trigger every 15 minutes didn't. Eventually I had to just print out the value for each variable and found that I defined 15 minutes as 15 * 60 * 60...
e.g. I define every constant separately, and ideally any constant defined by an operation will only have one such operation. This makes mistakes _much_ easier to spot.
But those don't increase the number of seconds in the day. Instead, the final second happens twice.
This is different from what happens in leap year, where February is actually lengthened and February 29 is considered a different day from February 28. It escapes me why leap seconds aren't treated that way. (I know, people say the stupid treatment of leap seconds is required by the POSIX definition of time. So what? Change the POSIX definition.)
It's really a matter of who's going to catch your typos. If you use the constant built into your language, millions of people are looking at it. If you type them into your throwaway bash script, nobody is going to notice you typed 60 * 60 * 24 * 356 to get a year's worth of seconds.
Magic numbers something something. If your language provides it as a constant, why not use that? You’ll always get the correct value AND a descriptive name for free.
