Diffence between two date in sql server

Question

How To Find the Date difference from the current date?

Roei Bar · Answer

here you go: CREATE PROCEDURE dbo.CalculateAge @dayOfBirth datetime AS DECLARE @today datetime @thisYearBirthDay datetime DECLARE @years int @months int @days int SELECT @today = GETDATE() SELECT @thisYearBirthDay = DATEADD(year DATEDIFF(year @dayOfBirth @today) @dayOfBirth) SELECT @years = DATEDIFF(year @dayOfBirth @today) - (CASE WHEN @thisYearBirthDay > @today THEN 1 ELSE 0 END) SELECT @months = MONTH(@today - @thisYearBirthDay) - 1 SELECT @days = DAY(@today - @thisYearBirthDay) - 1 SELECT @years @months @days GO MARK this as Accepted Answer if you like it...

Kirtan Patel · Answer

select CreatedDategetdate() as 'Current'datediff(ddgetdate()CreatedDate) from Table_1 Use GetDate() parameter First

Purushottam Rathore · Answer

i m using these queries: select top 1 CreatedDate GETDATE() AS 'Current Date' Datediff (day CreatedDate GETDATE()) As 'age difference in day' from tablename select top 1 CreatedDate GETDATE() AS 'Current Date' Datediff (month CreatedDate GETDATE()) As 'age difference in month' from tablename select top 1 CreatedDate GETDATE() AS 'Current Date' Datediff (year CreatedDate GETDATE()) As 'age difference in year' from tablename but I am not getting correct difference....