sql根据身份证计算年龄

        FLOOR(DATEDIFF(CURRENT_DATE,p.Birth)/356) patientAge,
        YEAR (NOW()) - SUBSTR(p.idcard, 7, 4) AS patientAge,
        TIMESTAMPDIFF(YEAR, SUBSTR(p.idcard, 7, 8), CURDATE()) AS patientAge,
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/guagua-join-1/p/9754311.html