Subject Re: Age Calculation
Author gorepj
--- In, Helen Borrie <helebor@...>
> At 11:35 PM 28/11/2008, you wrote:
> >I need to add a computed column to a table to evaluate a person's
> >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