select DATEADD(dd, -2, CAST([DateColumn] as datetime)) AS [Date] FROM MyTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)