Subject Re: [firebird-support] Average age
Author Andrea Raimondi
Hans Hoogstraat wrote:
> I think the ???? can be the internal FB variable 'current_date'

Hi Hans,

First of all, thank you for the prompt answer.
I am not sure, though, that it can be of any help, since I
already tried current_date, but when I get to execute it, the
server says:

"Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Client SQL dialect 1 does not support reference to DATE datatype."

The SQL statement completed with current_date looks like this:

Select avg( ( extract( year from current_date ) - extract(year from DOB) )
count( * ) )from TblPerson where( Sex = 'Female' )

That's why I added the "additional infos".