How to get number of days in between two dates
select DATEDIFF(DAY,'2016-03-11 12:00','2016-03-13 20:00')
DECLARE @d1 DATETIME = '2016-03-11 12:00' DECLARE @d2 DATETIME = '2016-03-13 20:00' SELECT CAST(@d2 AS FLOAT) - CAST(@d1 AS FLOAT) -- Returns: 2.33333333333576
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)