DECLARE @da datetime, @a datetime SET @da = '20080101' SET @a = CURRENT_TIMESTAMP SELECT DATEDIFF(day, @da, @a) AS Giorni; /* Output: Giorni ----------- 44 (1 row(s) affected) */
select @totale_giorni = datediff(dd, @data_inizio, @data_fine)
DECLARE @da datetime, @a datetime, @giorni int; SET @da = '20080101'; SET @a = CURRENT_TIMESTAMP; SET @giorni = DATEDIFF(day, @da, @a); SELECT @giorni AS Giorni; /* Output: Giorni ----------- 44 (1 row(s) affected) */