>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