Parsing date with MySQL

I have a date of the type

August 15, 2009

I'm trying to parse it with

DATE_FORMAT('August 15, 2009', '%M %e, %Y')

But it is not working returns NULL.

Oh mighty overflowers, do you have any idea what might be the problem?

See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

mysql> SELECT STR_TO_DATE('May 1, 2013','%M %d,%Y');
        -> '2013-05-01'