Subject | Re: [firebird-support] Age Calculation |
---|---|
Author | Helen Borrie |
Post date | 2008-11-28T12:53:56Z |
At 11:35 PM 28/11/2008, you wrote:
./heLen
>I need to add a computed column to a table to evaluate a person's age.(DateDiff(Month, BirthDate, CURRENT_DATE)) /12.00
>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
./heLen