根据身份证号码字段修改(补充)出生日期字段
UPDATE xl_personnel cp
SET cp.birth_date = (
cast( substr( cp.idcard, 7, 8 ) AS date ))
WHERE
cp.idcard IS NOT NULL
AND length( cp.idcard ) = 18
根据身份证号码字段修改(补充)出生日期字段
UPDATE xl_personnel cp
SET cp.birth_date = (
cast( substr( cp.idcard, 7, 8 ) AS date ))
WHERE
cp.idcard IS NOT NULL
AND length( cp.idcard ) = 18