Date Difference in SQL Server in Days, Hours, Minutes and Seconds

A lot of users often ask questions related to finding difference between two date. The results are expected in Days, Hours, Minute and Seconds. Here’s a query that shows how to find the difference between two dates in SQL Server Here’s the query in a readable format to try outDECLARE @Startdate DATETIME, @Enddate DATETIMESET @Startdate = '2011-01-02 11:35:26'SET @Enddate = '2011-01-06 03:15:31'--