日期格式无效

I have the following select statement.

$sql = "SELECT *, DATE_FORMAT(date, '%d-%m-%Y') FROM alerts";

I use the following PHP code to echo

 echo "" . $row["date"]."";

No matter what I do I receive Year-Month-Day instead of Day-Month-Year. Any ideas?

You can use echo date_format($row["date"], "d/m/Y");