Convert TIME to Seconds in MSSQL
Just put in the Time, and it will return the Seconds DECLARE @Time Varchar(10) SELECT DATEDIFF(second,0,cast(@Time as datetime))
As technology is going advance.. there is many things we need to keep in pace..