CREATE Function Dbo.GetAge
(
@birthday datetime,
@now datetime
)
Returns int
As
Begin
Declare @Age int, @year int, @month int, @Day int
Set @age =
Set @year =
Set @month =
Set @day =
Set @year = DatePart(Year,@Now) - DatePart(Year, @BirthDay)
Set @month = DatePart(Month,@Now) - DatePart(Month, @BirthDay)
Set @Day = DatePart(Day,@Now) - DatePart(Day, @BirthDay)
if( @month > )
Set @Age = @Year
if( @month < )
Set @Age = @Year -
if(@month = )
Begin
if( @Day >= )
Set @Age = @Year
Else
Set @Age = @Year -
End
Return(@Age)
End