convert full date string to date mysql

I have database which contains string like this

22 Jan 2019 11:03

I would like to convert this string to date so I apply this query

select DATE_FORMAT(STR_TO_DATE('22 Jan 2019 11:03','%d-%m-%Y') ,'%d-%m-%Y');

​x
 
select DATE_FORMAT(STR_TO_DATE('22 Jan 2019 11:03','%d-%m-%Y') ,'%d-%m-%Y');​

but I get a null result

Answer

All you have to do is change small letter m to big letter M in your str_to_date function.

select STR_TO_DATE('22 Jan 2019 11:03','%d %M %Y');

 
select STR_TO_DATE('22 Jan 2019 11:03','%d %M %Y');​

so the final query would be:

select DATE_FORMAT(STR_TO_DATE('22 Jan 2019 11:03','%d %M %Y') ,'%d-%m-%Y');

 
select DATE_FORMAT(STR_TO_DATE('22 Jan 2019 11:03','%d %M %Y') ,'%d-%m-%Y');​