CONCAT_WS('分隔符',字符1,字符2,字符3,)
substring(identity_card_number,7,4) 是截取身份证,从第七个开始,取4个,不是从0开始
str_to_date 字符转日期
SELECT id, name,identity_card_number,date_birth ,
str_to_date(
CONCAT_WS('-',substring(identity_card_number,7,4),substring(identity_card_number,11,2),substring(identity_card_number,13,2))
, '%Y-%m-%d')
FROM hr_pool WHERE create_user = 111112 ;