Tag Archives: date and time difference

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 )

.