SELECT DATEDIFF(day, date1,date2) AS DateDiff /* DATEDIFF accepts three arguments 1- day, month, year etc what form you need difference 2,3- dates */