sql BETWEEN

[Stan Busk]

So if it is inclusive BETWEEN has a bug, doesn't it?

> On 13/2/07 9:15 PM, "Stan Busk" <maxprog at mac.com> wrote:
>
>> Hi,
>>
>> I don't remember (and can't find in the doc), is BETWEEN inclusive?
>
> yes
>
>> In a query I have:
>>
>> myDate BETWEEN '01/01/06' AND '01/31/06'
>>
>> It returns everything between 01/01 and 01/30 rather than 01/01 and
>> 01/31 ?
>>
>> Should I modify my query to
>>
>> myDate BETWEEN '01/01/06' AND '02/01/06' ?
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina