I don't believe that DateDiff is available in Firebird 2.0.3. I installed Firebird 2.1.2 and the DateDiff function is now available.

--- In firebird-support@yahoogroups.com, "thedevguy" <stinkyduck@...> wrote:
>
> Has the DateDiff function been deprecated? I can't seem to get a simple query like this to work
>
> select datediff(
> second, cast(current_date as timestamp), current_timestamp)
>
> I get an unknown token for second (Using Database Workbench v2.8.8b Pro).
>