1. 粗略计算
datediff(year, BirthDay, getdate())
2. 精确计算
floor((DateDiff(day, BirthDay, getdate()))/365.25) age
datediff(year, BirthDay, getdate())
floor((DateDiff(day, BirthDay, getdate()))/365.25) age
本文标题:SQL Server 出生日期计算年龄
本文链接:https://www.haomeiwen.com/subject/yrvzsktx.html
网友评论