摘要： -- 身份证号中提取出生日期 SELECT id,name,id_card,birth_date,gender,length(id_card), str_to_date(substring(id_card, 7, 8), '%Y%m%d') as birth_date2 FROM `wk_staff 阅读全文