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,