Question: how to convert date format from dd/mm/yyyy to yyyymmdd 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.