>>Anyone know how to calculate the age from a date of birth in a sql statement.
>>Date of birth is stored in a datetime field (DOB).
>>
>>Example:
>>
>>select lastname,firstname,dob,age
>
>

select lastname,firstname,dob, Datediff(Month, dob, getdate())/12 as age

Sergey;

I thought if I just asked my mother I could get a quick answer! :)

Tom