Question: how to convert dd-mm-yyyy to yyyy-mm-dd 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.