Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Birthdate to Age

Status
Not open for further replies.
Sleidia

Sleidia

Technical User
Joined
May 4, 2001
Messages
1,284
Location
FR
Here is a way to find out the age of someone from his birthdate stored in a date field called "birthdate" (YYYY-MM-DD) :

SELECT FLOOR(PERIOD_DIFF(LEFT(CURDATE()+0, 6),LEFT(REPLACE(birthdate, '-', ''), 6)) / 12) AS age FROM ... etc...

That's all!

-----------------------------
 
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question Question
Looking for suggestions on how to do this
Replies
4
Views
822
Chris Miller
Chris Miller
E
  • Locked
  • Question Question
MySQL calculator tools
Replies
0
Views
663
EdZzy
E
EdLentz
  • Locked
  • Question Question
Need to compare two tables and list the differences
Replies
3
Views
1K
EdLentz
EdLentz
waubain
  • Locked
  • Question Question
Reset cumulative sum to zero on every year
Replies
8
Views
1K
waubain
waubain
eizs002
  • Locked
  • Question Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
615
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top