Jonathan wrote:

> Sorry you are forced to use something as great as Firebird :-). I assume LAST_MODIFIED_ON is a TIMESTAMP field in your table and is being updated via a trigger or some other mechanism as records are modified. Your DATEDIFF syntax is incorrect; try:
>
> ... WHERE LICENSE_PLATE_NO<>'No plate found' AND DATEDIFF(second,LAST_MODIFIED_ON,current_timestamp)<120
>
> or
>
> ... WHERE LICENSE_PLATE_NO<>'No plate found' AND DATEDIFF(minute,LAST_MODIFIED_ON,current_timestamp)<2

This should work, but it's not Jupiter's syntax that was incorrect. The FROM .. TO syntax is fully supported. Point is, you're not allowed to mix TIME and TIMESTAMP arguments with DATEDIFF (DATE and TIMESTAMP is OK though). So, since LAST_MODIFIED_ON is obviously a TIMESTAMP, current_time should be current_timestamp - as in your corrected example.

http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-datediff.html


Cheers,
Paul Vinkenoog