SQL Query Beetween <Month> AND <Month>?

i will definitely return only records from "oct 1 2007"

to "nov 1 2007"... ^^

im in mssql and i can't see why ur expecting records from

Feb...

in tsql, if you omit the month, it will default to "january",

if day is omitted, it will default to "1",

and if time is omitted, will default to "12:00:00 AM"...

and in addition, your records may have the time part on them,

that will make them fail in your criteria..

here's a code( in tsql) if you want to remove the timepart)

cast(convert(varchar, getutcdate(),112)as datetime)

i hope that i helped in anyways.. peace out.. ^_^v

it looks as if You have only asked for the month of October..if You are wanting a year..You may have to add that to the query.

*S* Good luck! or You may try reversing the order and asking for records from the month of Nov. thru the month of Oct, 2007..

Use this

Date > 10/?/2007 and Date < 11/?/2007

Depends on the RDBMS, some implement a month function, or a function to convert to text. If that is the case, change the date to YYYYMM and do your between.

Did you try changing NOV to DEC?

SELECT *

FROM SNTPEN

WHERE (HB_DATE BETWEEN 'OCT 2007' AND 'DEC 2007')