date difference??

[priti]

Its a very newbie type question but i got stuck!!!

i want to find date difference between currdate and DOB field from a table.

Let me know the query please

[guelphdad]

check the manual for DATE_SUB, DATE_ADD or interestingly DATEDIFF

[r937]

the problem with DATEDIFF is that it returns the number of days

i'll bet a doughnut and coffee that priti is looking for age in years, not days

hint: DOB column

[priti]

You right !!! i am looking it to make in year not in Day ...in days i was able to find but then i need years .......

let me paste my query

select TO_DAYS(YEAR(curdate()),MONTH(curdate()),DAY(curdate())-TO_DAYS(CONCAT_WS("-",DOBYY,DOBMM,DOBDD)) from table

but it is in days !!

correct this query !!

[r937]

see http://www.sitepoint.com/forums/showthread.php?t=358038