Using Month and year only to get all data

[davide++]

Hi all

A part from September constains 30 days, no 31, you should use DatePart function, as Shuja Ali said.
So a query that solves your problem may be

SELECT vessel, voyage
  FROM dneirout
 WHERE DatePart('m', CONTAINER_OUT_DATE) = 9
   AND DatePart('yyyy', CONTAINER_OUT_DATE) = 2007