ORDER BY DATE

[Mauro Perez]

Hello i want someone to help me with this:
I need to order by date descendent in a php-mysql script im using the next line

SELECT * FROM `novedades` ORDER BY DATE_FORMAT(fecha, "Y-m-d") DESC LIMIT 0,25;

i tried also with

SELECT * FROM `novedades` ORDER BY DATE_FORMAT(fecha, "Y-m-d") ASC LIMIT 0,25;
and
SELECT * FROM `novedades` fecha ASC LIMIT 0,25;
and
SELECT * FROM `novedades` fecha DESC;
etc...etc...etc...