Subject age calculation
Author Fernando Salaices
Hello all.

I have a question about how to calculate the correct age of a person
using the date of birth. I'm trying something like this:

cast('10/20/2005' as date) AS CURRENTDATE
,(cast((current_date - cast('10/21/1974' as date)) as float)/365) as
from rdb$database;

In this query, I subtract from the current date (october 20, 2006 in
this case) the DOB (october 21, 1974). It should give me a number just
below 32, but I get 32.0191780821918

I thought it was a rounding error, that is why I started casing to FLOAT.

What am I doing wrong?


Fernando Salaices.