using DateDiff to find duration in minutes

sql sql-server tsql datediff
Doug Ancil picture Doug Ancil · Nov 1, 2010 · Viewed 85k times · Source

I am trying to use Datediff to find out the duration between columnA and columnB. 

SELECT datediff (minute, stime, etime)
from Exceptions2
where stime = [exceptions2].starttime
and etime = [exceptions2].endtime

This produces errors. Can anyone please help me with what I'm doing wrong?

Answer

Raymund picture Raymund · Nov 1, 2010

how about trying this, not sure why you have stime = [exceptions2].starttime and etime = [exceptions2].endtime

SELECT datediff(minute, starttime, endtime) from Exceptions2

Related questions

how to get the number on months between two dates in sql server 2005

I have a column in my sql server 2005 table that should hold the number of months an employee has been in service. Since I also have the date the employee was engaged, I want the "months_In_Service" column to …

Read More
SQL Datediff - find datediff between rows

I would like to query a database using sql to show the difference in time between id 1,2,3 and so on. basically it will compare the row below it for all records. any help would be appreciated. IDCODE DATE TIME DIFFERENCE (…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More