一、使用内置函数timestampdiff()
select timestampdiff(year, substring('622201199812316616', 7, 8), now()) as age;
二、分段计算
select (substring(now(),1,4)-substring('622201199812316616',7,4))-(substring('622201199812316616',11,4)-date_format(now(),'%m%d')>0) as age