Comments by Baliram Suryawanshi (Top 2 by date)

Execute below statement with hard coded time:
-- With Specified time

SELECT DATEDIFF(mi, '12:34:34', '12:34')/60;

It should not give any error. It works with SQL server 2012 as well.


If you are getting error in the scripts when you execute it with column names then it must be due to invalid data available in your column. With invalid I mean non-datetime data.
If it is case, first try to convert the invalid data in Time.