mysql 根据身份证号输出年龄(15位,18位都可.)
SELECT
CASE
WHEN LENGTH(s.CARD_ID)=18 THEN YEAR (now()) - YEAR (substring(s.CARD_ID, 7, 8))
WHEN LENGTH(s.CARD_ID)=15 THEN YEAR (now()) - YEAR(STR_TO_DATE(CONCAT('19',substring(s.CARD_ID, 7, 2)),'%...
原创
2019-08-20 19:02:34 ·
1932 阅读 ·
1 评论