DECLARE @endTime DATETIME = '18:00' DECLARE @duration DATETIME = '1:45' SELECT CONVERT(TIME(0), ((@endTime - @duration)))
declare @d1 datetime='2010-01-01 01:45'; declare @d2 datetime='2010-01-01 18:00'; SELECT CONVERT(varchar,datediff(MI, @d1, @d2)/60) +':'+ CONVERT(varchar, datediff(MI, @d1, @d2)-60*(datediff(MI, @d1, @d2)/60))
select CAST((CAST(FLOOR(18.00) * 60 + FLOOR(100 * 18.00) % 100 AS INT)-CAST(FLOOR(1.45) * 60 + FLOOR(100 * 1.45) % 100 AS INT))/60 + (CAST(FLOOR(18.00) * 60 + FLOOR(100 * 18.00) % 100 AS INT)-CAST(FLOOR(1.45) * 60 + FLOOR(100 * 1.45) % 100 AS INT))%60 *0.01 AS DECIMAL(5,2))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)