SQL DateTime And Searching For Just The Date Portion

I have a SQL DB with a column called time_occurred that is formatted like ( 7/28/2004 7:10:30 AM ).





What I need to do is run a report based on just the month day and year portion. I am using the calendar control so mins, sec and milliseconds are not available nor do I really need them.





I am running the Query with this Stored Procedure











ALTER PROCEDURE dbo.Prodecure1


(


@WhereClause varchar(8000)


)





AS





-- Create a variable @SQLStatement


DECLARE @SQLStatement varchar(8000)





-- Enter the dynamic SQL statement into the variable @SQLStatement


SELECT @SQLStatement = 'SELECT column1, column2, etc...' +


@WhereClause





-- Execute the SQL statement


EXEC(@SQLStatement)





RETURN