sql BETWEEN

[Ruslan Zasukhin]

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]