The Year 2079 Bug
And you thought Year 2000 was the last of it. Remember the scare tactics? Your toaster will stop working, cats and dogs living together? Complete mayhem. It was great for the consultants and billable time though, wasn’t it?
It’s going to happen again, for you SQL Server folks. You’ve been saving bytes with the smalldatetime column type haven’t you? Who needs those pesky seconds, or the fact that the time is only valid to 3/100ths of a second.
Unfortunately for you, the smalldatetime has a time-bomb as well. According to Microsoft’s Books Online:
Date and time data from January 1, 1900, through June 6, 2079, with accuracy to the minute. smalldatetime values with 29.998 seconds or lower are rounded down to the nearest minute; values with 29.999 seconds or higher are rounded up to the nearest minute.
So plan to be on vacation in the summer of ’79 because it’s all going to end. But your biggest concern at this point is that you probably won’t be alive to reap all that billable time spent refactoring date columns.
I really need to fill this out at some point. 
Pingback: Anonymous