Tag: SQL

Here’s a quickie… Calculate someone’s age with SQL:

select dob, 
    floor(datediff(day, dob, getDate()) / 365.25) as age 
    from personnel