Get the Difference Between two Dates in SQL Server

Updated on August 30, 2015     Kisan Patel

This tutorial will show you how to get the difference between two dates in SQL Server?

To get the difference between two dates, we can use DATEDIFF function.

SELECT
DATEDIFF(YY, '01/24/1977', GETDATE()) AgeInYears,
DATEDIFF(MM, '01/24/1977', GETDATE()) AgeInMonths,
DATEDIFF(DD, '01/24/1977', GETDATE()) AgeInDays

Here, we have pass first parameter as different interval values. So, we can get year, month and days. Here, the SQL query will return difference of two dates in year, month an days respectively.