[Age] AS (case when datepart(month,[Birthday])>=datepart(month,getdate()) AND datepart(day,[Birthday])>=datepart(day,getdate()) then datepart(year,getdate())-datepart(year,[Birthday]) else (datepart(year,getdate())-datepart(year,[Birthday]))-(1) end),
生日计算列公式分享一下
最新推荐文章于 2024-01-08 12:23:56 发布