Actual Y2K Bug (Public Board)

by FSK, Tuesday, November 05, 2024, 23:37 (263 days ago) @ JoFrance

There was an actual Y2K bug on the project I was working on at the time. It was an SQL script that was written in September 1999. It was designed to purge all old records from the database, which is itself a dumb idea since that feature was a negligible amount of data. For some reason, instead of doing DATEDIFF, they converted the DATE type to a string with a 2 digit year and then back to a DATE. This caused everything from Jan 2000 and later to look 99 years old, so it got deleted.


Complete thread:

 RSS Feed of thread