Answers for "how to get date difference in sql"

find difference in dates sql

SELECT DATEDIFF(day, date1,date2) AS DateDiff
/*
DATEDIFF accepts three arguments
1- day, month, year etc what form you need difference
2,3- dates 
*/

SQL: get date difference in minutes

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