| Subject | Re: [firebird-support] Why a certain expression in 'where' throws an error? |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2010-12-22T16:46:26Z |
Hi kokok,
The BETWEEN should definitely work!
Which version and dialect of Firebird are you using?
Paul Vinkenoog
>> CAST(OrderDate + CAST((LfAvgDays+0.5) AS INTEGER) AS DATE) BETWEEN '2009/1/1' AND '2010/1/1'Sorry, misread you SQL!
> Anyway: you can't cast dates to integers.
The BETWEEN should definitely work!
Which version and dialect of Firebird are you using?
Paul Vinkenoog