Please Help Me Get The Age From The Birthdate

[Guest]

Im making this stored procedure to return the age of the user to the web
control but the problem is that DATEPART(). I can only Specify one and i need
the age to to the exact format of mm dd yy but i cant get it into the Query
so it can execute. And when I use the yyyy to return the Age it returns the
age as between 1 - 11 months and between 1 - 364 days. So for example the
user was
borned 21.11.85. when executed it returns the user is 20 when their 20th is
4months away.

<SQL QUERY>
SELECT DATEDIFF(yyyy, Dob, GETDATE()) AS Age
FROM Basic
WHERE (UName = @UName)

 

[Jignesh Desai]

-- This is one correct way
SELECT DATEDIFF(YY,@BIRTH,@AGEAT) -
CASE WHEN (MONTH(@BIRTH) = MONTH(@AGEAT) AND DAY(@BIRTH) > DAY(@AGEAT)
OR MONTH(@BIRTH) > MONTH(@AGEAT))
THEN 1 ELSE 0 END AS 'Age correcting DATEDIFF'RegardsJignesh Desai -
MVPBlogs @ http://dotnetjini.jigneshdesai.com/Blogs/default.aspx.NET
Training Programs : http://dotnetjini.jigneshdesai.com/Training.aspx"eamon"

 

[Guest]

hi eamon

was this a repeated post?

SELECT DATEDIFF(d, Dob, GETDATE()) / 364 AS Years,
( 12 - ( datepart(m, dob) - datepart(m,getdate()))) % 12 AS Months
FROM Basic
WHERE (UName = @UName)

included your correction