Subject Re: [firebird-support] Age Calculation
Author Helen Borrie
At 11:35 PM 28/11/2008, you wrote:
>I need to add a computed column to a table to evaluate a person's age.
>What is the best way to calculate age? DateDiff(Year, BirthDate,
>CURRENT_DATE) seems only to take account of the year portion of the
>dates and not the month and day parts.
>Regards
>Peter Gore
>Using FB2.1

(DateDiff(Month, BirthDate, CURRENT_DATE)) /12.00

./heLen