How to Convert 'September 2014' to '2014-09-01' in mysql

Question

I Want To Change The Date format 'September 2014' to '2014-09-01' in Mysql I tried with Below Query

 SELECT STR_TO_DATE('May 1,2013','%M %d,%Y');

its working fine for 'May 1,2013' this format

but i am getting null while using 'September 2014' format

please help me

possible duplicate of [MySql MONTHNAME](http://stackoverflow.com/questions/7027129/mysql-monthname) — Nir Alfasi, Sep 13 '14 at 04:19
No Its Working Fine... Maheswaran Ravisankar Sorry By Mistake... — Dileep Kumar, Sep 17 '14 at 07:37

Maheswaran Ravisankar · Accepted Answer · 2014-09-13T04:41:37.677

2

 SELECT STR_TO_DATE(CONCAT('September 2013',',1'),'%M %Y,%D');

EDIT: Mysql expects, all the date fields, so, the above work around is needed, when you don't have the day number beforehand.

edited Sep 13 '14 at 04:41

answered Sep 13 '14 at 04:22

Thanks but i am getting '2014-09-00' instead of '2014-09-01' – Dileep Kumar Sep 13 '14 at 04:33

1 Answers1