SQL: Calculate Age Based on DOB

[ShiftPoint]

I had to come up with a sql query that would calculate a DOB based on a datetime field. This is what I came up with.

Code: Select all

select year(getdate())
     - year(DOB)
     - case when month(DOB) > month(getdate()) then 1
            when month(DOB) < month(getdate()) then 0
            when day(DOB) > day(DOB) then 1
            else 0
        end as age
  from HR