Getting the age of someone
Moderator: General Moderators
Getting the age of someone
Hi I know this may seem like a very basic question but I just don't seem to figure it out. I have a record in my Database which is the date of birth, and I want to know how old that person is. How could I do it?? My column in my DB is of type DATE. Thanks
- aaronhall
- DevNet Resident
- Posts: 1040
- Joined: Tue Aug 13, 2002 5:10 pm
- Location: Back in Phoenix, missing the microbrews
- Contact:
Code: Select all
SELECT DATEDIFF(birthdayColumn, CURDATE());