MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

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

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

null

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

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

2019-01-22

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

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

22-01-2019