Get Age From Given Date

Question

User-807418713 posted

Hello

In My Textbox1 In which date format is like this for example

15-Apr-1985

I want to show age in Textbox2

Answer 1

User475983607 posted

Hello

In My Textbox1 In which date format is like this for example

15-Apr-1985

I want to show age in Textbox2

Very Simple. Return the age using the same query you are using to get the birth date.

USE [AdventureWorks]
GO

SELECT [ModifiedDate],
	DATEDIFF(year,[ModifiedDate], GETDATE()) AS [Age]
  FROM [Person].[Person]
GO

Answer 2

User2053451246 posted

This function will return the correct age:

CREATE FUNCTION [dbo].[fn_GetAge] 
(
	@DOB AS DATETIME
	, @AsOfDate AS DATETIME
)
RETURNS INT
AS
BEGIN

	DECLARE @age INT

	IF CAST(DATEPART(M, @AsOfDate) AS INT) > CAST(DATEPART(m, @DOB) AS INT)

		SET @age = CAST(DATEDIFF(YYYY, @DOB, @AsOfDate) AS INT)

	ELSE

		IF CAST(DATEPART(M, @AsOfDate) AS INT) = CAST(DATEPART(m, @DOB) AS INT)

			IF DATEPART(D, @AsOfDate) >= DATEPART(d, @DOB)

				SET @age = CAST(DATEDIFF(YYYY, @DOB, @AsOfDate) AS INT)

			ELSE

				SET @age = CAST(DATEDIFF(YYYY, @DOB, @AsOfDate) AS INT) -1

		ELSE

			SET @age = CAST(DATEDIFF(YYYY, @DOB, @AsOfDate) AS INT) - 1

	RETURN @age
	
END
GO

Usage:

SELECT

    dbo.fn_GetAge(DOB, GETDATE())

FROM TableName

Answer 3

User-893317190 posted

Hi Gopi.MCA ,

You could also get age using c#.

Below is my code.

 DateTime time;
            int age = 0;
            if (DateTime.TryParseExact("15-Apr-1985", "dd-MMM-yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out time)) {
                while ((time= time.AddYears(1)) < DateTime.Now)
                {
                   
                    age++;
                }
            }
            Response.Write(age);

The result.

For more information , please refer to https://stackoverflow.com/questions/9/how-do-i-calculate-someones-age-in-c

Best regards,

Ackerly Xu