判断身份证号年龄大于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-05-09 22:38:32 发布
判断身份证号年龄大于80岁
select * from table
where length(sfzh)=18 and sfzh is not null and 2023 - cast(substr(sfzh,7,4)as int) >=80;