Do you want to know how many days are between 2 given dates?
Or how many months, weeks, hours, minutes or seconds?
Easy peasy!
Just check the following examples:
SELECT DATEDIFF(MONTH, GETDATE(), GETDATE() + 1) AS MonthDiff SELECT DATEDIFF(WEEK, GETDATE(), GETDATE() + 1) AS WeekDiff SELECT DATEDIFF(DAY, GETDATE(), GETDATE() + 1) AS DayDiff SELECT DATEDIFF(HOUR, GETDATE(), GETDATE() + 1) AS HourDiff SELECT DATEDIFF(MINUTE, GETDATE(), GETDATE() + 1) AS MinuteDiff SELECT DATEDIFF(SECOND, GETDATE(), GETDATE() + 1) AS SecondDiff
Syntax: DATEDIFF ( datepart , startdate , enddate )