1,105,208 Community Members

Trying to do a derived attribute in MySQL

Member Avatar
barb.saunders.5
Newbie Poster
3 posts since Dec 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi im a beginner in mysql land and i need to derive AGE from my D.O.B column i am wondering

if someone could explain how

and whether you could break it down more simply...

i know im asking alot but we all have to learn ..

thanks

hopefully

barb :D

Member Avatar
pritaeas
mod_pritaeas
11,285 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,831 [?]
Skill Endorsements: 154 [?]
Moderator
Featured
Sponsor
 
0
 

You can just use a regular query and use DATEDIFF with NOW. Read more here.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article