判断身份证号年龄大于80岁
select * from table
where length(sfzh)=18 and sfzh is not null and 2023 - cast(substr(sfzh,7,4)as int) >=80;
判断身份证号年龄大于80岁
最新推荐文章于 2024-08-12 23:11:19 发布
判断身份证号年龄大于80岁
select * from table
where length(sfzh)=18 and sfzh is not null and 2023 - cast(substr(sfzh,7,4)as int) >=80;