Calculating Age median from list of Dates of Birth

[romanisa]

Hii friends

I need to calculate the age median from the given dates of birth in an employee database in MS SQl.

Please help...

Roma

[Delerna]

do a datediff between the current date and their birth date
then take the average
for example in months it is

SELECT avg(datediff(m,getdate(),birthdate))
FROM employees

is that what you mean

[deepuv04]

Hii friends

I need to calculate the age median from the given dates of birth in an employee database in MS SQl.

Please help...

Roma

Hi,


for calculating the age use the following sample query and change it according to your requirement


DECLARE @FromDate DATETIME,
@ToDate DATETIME

SELECT @FromDate = '1983-07-04',@ToDate = '2008-07-04'

SELECT CASE WHEN @FromDate > @ToDate THEN NULL
WHEN DATEPART(day, @FromDate) > DATEPART(day, @ToDate) THEN DATEDIFF(month, @FromDate, @ToDate) - 1
ELSE DATEDIFF(month, @FromDate, @ToDate)
END / 12.0


thanks

[deepuv04]

do a datediff between the current date and their birth date
then take the average
for example in months it is

SELECT avg(datediff(m,getdate(),birthdate))
FROM employees

is that what you mean

Hi,

if the birth date is 2007-01-31 and today is 2008-02-01 and
in the code SELECT avg(datediff(m, getdate(),birth date))
FROM employees the function datediff(m,getd ate(),birthdate ) will give you the difference as 1 month though it is differ by 1 day.

[Delerna]

Hi,

if the birth date is 2007-01-31 and today is 2008-02-01 and
in the code SELECT avg(datediff(m, getdate(),birth date))
FROM employees the function datediff(m,getd ate(),birthdate ) will give you the difference as 1 month though it is differ by 1 day.

Then use days
avg(datediff(d, getdate(),birth date))

[romanisa]

Hey Thanks everyone for the code....