mysql 截取身份证出生日期

select idno as 身份证号, cast(substring(idNo,7,8) as date) as 出生日期, DATE_FORMAT(cast(substring(idNo,7,8) as date), '%m-%d') as 生日  from t_person

版权声明：本文为huanyu12原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。