1、用datediff函数
select datediff(yyyy,StuBirthday,getdate())>17
2、用year函数
select (year(getdate()-year(StuBirthday))
1、用datediff函数
select datediff(yyyy,StuBirthday,getdate())>17
2、用year函数
select (year(getdate()-year(StuBirthday))
转载于:https://www.cnblogs.com/selfimprove/p/3310264.html