select ... from yourobject where mydatetimecol between @dateBegin and @dateEnd

select ... from yourobject where datepart(mm,mydatetimecol ) = @monthNo

where Mydate >= StartDateTime and Mydate < EndDateTime-- To get data from January of 2007where Mydate >= '20070101' and Mydate < '20070201'

WHERE SomeDate >= '2008/01/01 12:00:00:000 AM' AND SomeDate <= '2008/01/01 11:59:59:997 PM'

WHERE somedatecolumn >= '2008/01/01' AND somedatecolumn < '2008/01/02'

WHERE somedatecolumn >= '2008/01/01' AND somedatecolumn < '2008/02/01'