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
100字范文,内容丰富有趣,生活中的好帮手!
时间:2019-10-16 17:43:27
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
小学一年级国庆节日记:我和我的家人一起庆祝100字 日记50字:国庆节快乐 和家人一起
2024-07-20