Código SQL:
Ver originalSELECT DATE_FORMAT(fecha,'%d/%m/%Y') AS xxx FROM xxx WHERE DAY(fecha)='$dia';
SELECT DATE_FORMAT(fecha,'%d/%m/%Y') AS xxx FROM xxx WHERE MONTH(fecha)='$mes';
SELECT DATE_FORMAT(fecha,'%d/%m/%Y') AS xxx FROM xxx WHERE YEAR(fecha)='$ano';
saludos