Subtract two time values in SQL Server

Question

How to subtract two time values in SQL Server 2008. I am using time variables in a stored procedure.

Please help.

Answer 1

You can use DATEDIFF():

SELECT DATEDIFF(Day, startDate, endDate)
  FROM table

SELECT DATEDIFF(Second, date, GETDATE())
  FROM table