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
转载于:https://www.cnblogs.com/linjiqin/p/6249258.html
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
转载于:https://www.cnblogs.com/linjiqin/p/6249258.html