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 CreatedDate,getdate() as 'Current',datediff(dd,getdate(),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....

Diffence between two date in sql server

Answers (3)