Subject Re: [firebird-support] Using Datediff
Author Mark Rotteveel
On 22-6-2013 01:42, Alan J Davies wrote:
> Where do you declare "today"?
> This is an example:
> select datediff( day, (select current_date from rdb$database), (select
> current_date-10 from rdb$database))
> from rdb$database
> gives an answer of -10
> so if you substitute this code:
> > datediff(day, (select current_date from rdb$database),
> w_shipments.begin_fill_date)
> that will work if you have no other errors.

You can use current_date directly in a query, there is no need to select
current_date from rdb$database, so this will work as well:

select datediff(day, current_date, current_date-10)
from rdb$database

Mark Rotteveel