I don't see a big problem with this. About all you need to do to fix it is change to datetime in the table and the stored procedures that use it. The application code will probably not need to change much (if at all) since most programming languages don't have different size date types. Hopefully all the data access code in the application would be auto-generated by 2079 anyway Then you would just need to rebuild the data access layer and you're done.