Date-difference will give difference in the number of days, months, years etc
This tag may refer to 1) the difference between two numbers (i.e
"Datediff becomes more difficult to use as you have more dateparts in your difference in your case looks like minutes and seconds"
from question "Transact-SQL to sum up elapsed time"
"Note that diffseconds can cause an overflow when the difference becomes larger than int32.maxvalue error the datediff function resulted in an overflow"
from question "'Ticks' is not supported in LINQ to Entities"