At 10:26 AM 19/08/2012, Paul Vinkenoog wrote:

>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.

Everything he said; plus, if you are not using Firebird 2.5, the SECOND argument is not supported if LAST_MODIFIED_ON is a DATE type.

./h