Datediff() Function to Show Date Difference in Days Hours Minutes

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