--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> 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
>

Unfortunately this approach makes the following evaluation 21 whereas
it should not be 21 until 25-nov-2021
select (DateDiff(Month, CAST('25-nov-2000' as Date), CAST('1-nov-
2021' as Date))/12) from rdb$database