select datediff(year,出生日期,getdate()) FROM 表格
select Cast(YEAR(Getdate()) as int ) - Cast(YEAR(出生日期) as int) as age from 表名
