Using Month and year only to get all data

[hspc]

Hi, i am using Microsoft SQL Server Management Studio Express,

Maybe I try defining my problem here, I would like to do a monthly consolidation of records if the user intend to look at .for example September 2007, so i will extract all the data from 1/09/2007 to 31/09/2007.
HTH

This will extract records in sept.:

SELECT vessel, voyage
FROM dneirout
WHERE
DATEDIFF(month,CONTAINER_OUT_DATE,'20070901')=0

Also the solution that davide++ mentioned will work.