select date_part('year',age(CURRENT_DATE,to_date(substr(syrsfzh,7,4),'yyyy'))) as age ,syrsfzh FROM "tbl_vehicle_file"
sql 根据身份证号计算年龄
最新推荐文章于 2024-03-21 16:30:27 发布
select date_part('year',age(CURRENT_DATE,to_date(substr(syrsfzh,7,4),'yyyy'))) as age ,syrsfzh FROM "tbl_vehicle_file"