Try this, it returns an empty result:

 

SELECT str_to_date('2010-05-02','YYYY-MM-DD')

 

I discovered this because when trying to select records in a certain date range, the WHERE clause is failing on the date comparison. Nothing is being returned.