Fai una cosa, rigira la query così

codice:
SELECT MAX(temp) AS maggiore, 
date_format(datetime,'%d-%m-%Y') as giorno 
from meteo 
WHERE date_format(datetime,'%Y-%m-%d') BETWEEN 
'2008-03-15' AND '2008-03-16' 
GROUP BY giorno ORDER BY datetime