Sql Server: Calculate Age in years from Date of Birth (DOB)

In this article I am going to explain how to calculate the age in years from given Date of Birth in Sql.

In the previous article I have explained how to show default image if image ismissing or not uploaded using angularjs with asp.net mvc, how to displaymessage when ng-repeat filter is empty or null using AngularJs with MVC and howto perform Create, read, Update and Delete (CRUD) operations in Asp.net MVC 5using AngularJs.

Implementation:

You can calculate the age from DOB using below given methods:

Method 1:

Declare @DOB DATE ='09/28/1980'

Declare @Currentdate date = getdate()

SELECT [Date Of Birth] = @DOB,[Current Date]=@Currentdate,[Age]=DATEDIFF(yy,@DOB,@Currentdate)

Method 2:

SELECT [Age in Years] = DATEDIFF(DAY, '09/28/1980', GetDate()) / 366

Method 3:

Declare @DOB DATE ='09/28/1980'

Declare @Currentdate date = getdate()

SELECT[Date of Birth] = @DOB,[Current Date]=@Currentdate,[Age]=DATEDIFF(yy,@DOB,@Currentdate)-

   (CASE WHEN DATEADD(YY,DATEDIFF(YEAR,@DOB,@Currentdate),@DOB)>  @Currentdate THEN 1 ELSE 0 END)

Method 4:

Declare @DOB DATE ='07/28/1980'

Declare @Currentdate date = getdate()

SELECT [Date Of Birth] = @DOB,[Current Date]=@Currentdate,[Age]=DATEDIFF(dd,@DOB,@Currentdate)/365.25