I ran into a problem where Excel and SQL Server have different "zero day" date conventions, so that all the dates currently in one of my tables are two days ahead of where they should be. Is there an easy way to update all the dates?
I know I can do something like
SELECT DatabaseID, P60_Date, DATEADD(day, -2, P60_Date) AS NEW_P60_Date FROM US_P60
But I don't know how to UPDATE all the values in P60_Date with the new dates.