So you're trying to get all records for June 2003? Try this: SELECT * from curEvents where DATEPART(month, GETDATE()) = 6 and DATEPART(year, GETDATE()) = 2003