Subject Re: [firebird-support] Predicator between...and
Author Dimitry Sibiryakov
On 4 Jul 2006 at 11:08, bill_zwirs wrote:

>where RCPTDATE between '06/01/2006' and '06/30/2006'
>order by 1
>The result only lists all receipts between '06/01/2006'
>and '06/28/2006' inclusive. The table does contain records for the
>30th June - why aren,t they retrieved.

What type has RCPTDATE? Is it real DATE or some kind of TIMESTAMP?

SY, Dimitry Sibiryakov.