sql通过日期判断年龄函数的示例代码 sql通过日期判断年龄函数的示

定义函数：

CREATE FUNCTION [dbo].[GetAge](@BirthDay nvarchar(20) --生日)RETURNS varchar(20)ASBEGINif(@BirthDay is NUlL or @BirthDay='')return ''; -- Declare the return variable here DECLARE @age varchar(20) DECLARE @years int DECLARE @months int DECLARE @days int -- Add the T-SQL statements to compute the return value here set @age = '' set @years = year(GETDATE()) - year(@birthday) set @months = month(GETDATE()) - month(@birthday) if day(@birthday)<=day(GETDATE())set @days = day(GETDATE()) - day(@birthday) elsebeginset @months = @months - 1if MONTH(@birthday) in (1,3,5,7,8,10,12)set @days = 31-day(@birthday)+day(GETDATE())else if MONTH(@birthday) in (4,6,9,11)set @days = 30-day(@birthday)+day(GETDATE())else if MONTH(@birthday) = 2if (year(@birthday)%4 = 0 and year(@birthday)%100 <> 0) or year(@birthday)%400 = 0set @days = 29-day(@birthday)+day(GETDATE())elseset @days = 28-day(@birthday)+day(GETDATE())end if @months < 0beginset @years = @years - 1set @months = @months + 12end if @years = 0 and @months = 0 beginreturn convert(varchar,@days+1) + '天'end if @years > 0set @age = cast(@years as varchar(5)) + '岁' if @years < 3 and @months > 0 and @years>-1 beginset @age = @age + cast(@months as varchar(5)) + '月' end if @years<0 set @age='' RETURN @ageEND

【sql通过日期判断年龄函数的示例代码】使用函数：