In this post, Learn how to calculate total number. of days between two specific dates in SQL Server.
To get a total no. of days between two specific dates, you use the
DATEDIFF function of SQL Server.
declare @startDate datetime declare @endDate datetime set @startDate = '2019-01-01' set @endDate = '2020-01-01' select DATEDIFF(d, @startDate, @endDate) As 'Total No. of Days'
Total No. of Days
(1 row(s) affected)