mysql用身份证号算年龄性别生日
摘要：
性别 IF (MOD(SUBSTRING(o.patient_id_card,17,1),2),'男','女') AS gender, 年龄 (YEAR(CURDATE()) - SUBSTRING(o.patient_id_card,7,4)) AS age, 生日 cast(substring( 阅读全文
posted @ 2023-06-13 10:30 rachelgarden 阅读(57) 评论(0) 推荐(0) 编辑
