Michael Valentine Jones (9/25/2012)

---

You can use the function on the link below to find the age:
Age Function F_AGE_IN_YEARS
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74462

Jeff Moden (9/25/2012)

---

Careful now... Because of the date conversions to the CHAR datatype, that will be relatively slow.

Jeff Moden (9/25/2012)

---

Any chance of making it NOT a scalar function?

Jeff Moden (9/25/2012)

---

Any chance of making it NOT a scalar function?

SELECT DATEDIFF(yy, 0, GETDATE() - DOB) Age_Way1, 
           YEAR(GETDATE()-DOB) -1900 Age_Way2 

declare @dob datetime
set @dob = '2/29/2000'

select convert(char(10),@dob,101) as DOB,
case
when ((MONTH(@dob) * 100) + DAY(@dob)) > ((MONTH(getdate()) * 100) + DAY(getdate()))
then DATEDIFF(year,@dob,getdate()) - 1
else DATEDIFF(year,@dob,getdate()) End as AgeInYears