mysql indob,从MySQL中获取DOB的时代

I'm trying to show my members age in profile page. in php file i just added this code to show users birth day:

$data = $db->super_query( "SELECT dob FROM dle_users" );

$tpl->set("{bdate}", $data['dob']);

and in profile page i have this result:

1364-07-09

Its a Persian's date: yyyy-mm-dd

now i need to show members age, i searched in google and this site, i found some answers and tips, but in wont work for me! i don't know why.

how i can show age? :(

解决方案

You can use MySQL's TIMESTAMPDIFF() function:

SELECT TIMESTAMPDIFF(YEAR, dob, CURRENT_DATE) AS age FROM dle_users