Question: how to convert date format yyyy-mm-dd to dd-mm-yyyy in mysql?
Answer: Use STR_TO_DATE() method from MySQL to convert. The syntax is as follows wherein we are using format specifiers. The format specifiers begin with %. SELECT STR_TO_DATE(yourDateColumnName,'%d.