sql BETWEEN

Stan Busk maxprog at mac.com
Tue Feb 13 13:15:44 CST 2007


Hi,

I don't remember (and can't find in the doc), is BETWEEN inclusive?

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' ?

stan


More information about the Valentina mailing list