MS SQL select a datetime by month?

Question

How do you select a datetime column by month?

TABLE A
TITLE   MY_DATETIME   
blah    2011-03-26 05:44:43.213

SELECT * 
FROM TABLE A
WHERE MY_DATETIME = "August"

Answer 1

I use EXTRACT function instead of DATEPART. DATEPART function doesn't exist in my mysql.

Answer 2

SELECT * 
FROM TABLE A
WHERE DATEPART(month, MY_DATETIME) = 8

Or, less reliably based on language setting:

...
WHERE DATENAME(month, MY_DATETIME) = 'August'