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
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