Calculate the age of a person from his date of birth.
Parameters :
@dateNaissance = Date of birth
@dateActuelle = Current date (from GetDate())
CREATE FUNCTION [dbo].[fnGetAge] (@dateNaissance SMALLDATETIME, @dateActuelle SMALLDATETIME)
RETURNS INT AS
BEGIN
DECLARE @age INT
SET @age = FLOOR(DateDiff(dd,@dateNaissance,@dateActuelle)/365.25)
IF (Day(@dateNaissance) = Day(@dateActuelle)) AND (Month(@dateNaissance) = Month(@dateActuelle))
BEGIN
SET @age = @age + 1
END
RETURN @age
END