Parsing date with MySQL

Question

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?

Thank you :) You are right your edit makes more sense in a strict way, and we need to be strict when it comes to programming. — abcde123483
– abcde123483, Commented Jun 2, 2011 at 8:30

tofutim · Accepted Answer · 2011-06-02 07:55:32Z

8

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

answered Jun 2, 2011 at 7:55

tofutim

23.6k20 gold badges91 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

More specifically, DATE_FORMAT() expects a date, that's why it's unsuitable for the task.

Thanks I hadn't considered that :) Should have looked closer at the manual :)