Hi all,

Can anybody advise on how i can best use php and mysql to give a database record an "age" in days?

Im recording record creation via timestamp at the minute

Cheers

Paul

following code will return age in days for each user

SELECT username,datediff( current_date( ) , birthdate ) 
FROM datatable

following code will return age in days for each user
Help with Code Tags
PHP Syntax (Toggle Plain Text)
SELECT username,datediff( current_date( ) , birthdate )
FROM datatable

I thinks you are right!

can somebody help with a similar case. I have a table field that holds date of birth in the format; 1980/02/01. I need to display data based on months and days of birth alone.