本篇文章是对如何计算age的sql函数进行了详细的分析介绍，需要的朋友参考下

代码如下:ALTER FUNCTION [dbo].[get_FullAge](  birthday datetime, currentDay datetime)RETURNS INTASBEGINDECLARE age INTSET age = DATEDIFF(YEAR, birthday, currentDay)IF DATEDIFF(DAY, DATEADD(YEAR, age, birthday), currentDay) <= 0 SET age = age – 1IF DAT