How to use DATE_FORMAT() in mysql

$query = "SELECT DATE_FORMAT(DATETIME,'%m/%d/%Y') as NewDate,id FROM TableName ORDER BY DATETIME DESC";

result:
month(numeric)/day(numeric)/year(numeric)..

cheers :)