Aylar: Kasım 2018

DECLARE @minDateTime AS DATETIME = GETDATE()- 1; DECLARE @maxDateTime AS DATETIME = GETDATE(); ;WITH Dates_CTE AS (SELECT @minDateTime AS Dates UNION ALL SELECT DATEADD(hh, 1,…

DECLARE @start DATETIME = ‘2018-01-03 20:10:36.000’, @end DATETIME = ‘2018-01-03 22:10:37:000’ select IIF(convert(varchar(10), (DATEDIFF(SECOND, @start, @end ) / 86400)) = ‘0’, ”, convert(varchar(10), (DATEDIFF(SECOND, @start,…