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
