to_char(to_date(a.从身份证号码截取出生日期,'yyyy/mm/dd'),'mm')||to_char(to_date(a.从身份证号码截取出生日期,'yyyy/mm/dd'),'dd')fromhr_user_qy0331_oka不规则日期截取月日1963/12/2112211974/7/1007101985/1/601061973/8/808081966/8/508051958/12/812081964/6/1106111965/11/3011301972/10/1410141973/7/200720
updatehr_user_qy0331_oklsetl.login_name_new=substr(l.login_name,1,instr(l.login_name,'@')-1)||to_char(to_date(l.从身份证号码截取出生日期,'yyyy/mm/dd'),'mmdd')||substr(l.login_name,instr(l.login_name,'@'))wherel.从身份证号码截取出生日期isnotnullandl.同名否='same'andl.login_nameisnotnull
热搜榜
上海网站建设
赵姐商业
Donaldfef
MERGEL44
手赚术
游客0519
Miss Hu
Larryruita
