SELECT DATEDIFF(hh,GETDATE()-1,GETDATE()) AS DateDifference
SELECT DATEDIFF(day,'2013-02-07',GETDATE()) AS DateDifference
SELECT DATEDIFF(ww,'2013-02-07',GETDATE()) AS DateDifference