--- In firebird-support@yahoogroups.com, "Dion" <27824912424@...>
wrote:

>
> Tried that, but has no effect
>
> Ie
> select fc.contractoid, fl.*, (cnt.todate - (2/24)), cnt.todate
> from forklift fl
> join forkliftcontract fc on (fc.forkliftoid = fl.oid)
> join contract cnt on (cnt.oid = fc.contractoid)
>
> where :adate >= cnt.todate and :aDate <= (cnt.todate - (1/24))
>
> Regards,
> Dion

See my second post with correction

Adam