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.