How to format date ?

Hi,
I have a row with (date) format.
i.e:
1986-06-11
I want to format date to: d/m/Y
thank you

$query = "SELECT DATE_FORMAT(my_date, '%d/%m/%Y') AS my_formatted_date FROM my_table";