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]
