I am running this query

SELECT LICENSE_PLATE_NO, IMAGE_NAME FROM table WHERE (LICENSE_PLATE_NO<>'No
plate found') AND (DATEDIFF(second FROM LAST_MODIFIED_ON TO
current_time)<120)

the aim being to find all records modified in the last two minutes.

I get the error message

'[blah blah blah] expression evaluation not supported.'

Does this mean I cannot put a function in a Firebird SQL statement? I can
do this in MySQL and SQL Server without any problem. In this particulat
project, I am forced to use Firebird for legacy reasons.

Regards
Jupiter


[Non-text portions of this message have been removed]