SQL Server

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
 
 
Ebook Download
View all
Learn
View all
Membership not found