[MySQL] Date Formating

Hmm, I am trying to format a date from my news database. this is my query statement:


$query = "SELECT *, DATE_FORMAT(date_entered, '%c/%e/%y %r:%i') AS formatted_date FROM news ORDER BY date_entered DESC";

Any idea what I may have done wrong? or How I can fix this?