Continue reading...

Mysql::Replace Function Example, Y2k Fix

While migrating data from a non-y2k compliant system, I found myself with hundreds and hundreds of rows with this date error, instead of it being 12-20-1997, the old system was storing the dates like this 12-20-97, apparently not a problem for a web based system yet it represented a mayor issue when trying to pull out records with dates

Continue reading