mysql string to date

Question

How can I convert a string/varchar like '12-Mar-2013' to date like 2013-03-12?

I tried

SELECT STR_TO_DATE('12-Mar-2013','%Y-%m-%d');

SELECT DATE_FORMAT('12-Mar-2013','%Y-%m-%d');

but both return null.

My current database version is 5.5.7-rc.

Bjoern · Accepted Answer · 2013-03-13 08:21:47Z

5

Try

SELECT STR_TO_DATE('12-Mar-2013','%d-%M-%Y');

->   2013-03-12

answered Mar 13, 2013 at 8:21

Bjoern

16.3k4 gold badges47 silver badges50 bronze badges

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

Comments

Ed Heal · Accepted Answer · 2013-03-13 08:25:57Z

3

This should do the trick

SELECT DATE_FORMAT(STR_TO_DATE('12-Mar-2013','%d-%b-%Y'), '%Y-%d-%m');

answered Mar 13, 2013 at 8:25

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges