I have a problem with datagrid (7.7.7 and 7.9.9) with the date.Example:I have a query "date between '2013-08-10' AND '2013-08-12'" but i visualize only 2013-08-10 and 2013-08-11 and NOT 2013-08-12...I have the problem with all queries and also with filters......And when i filter with 1 day the query is empty, but the query on db is ok!HELP!!!!!!!

SELECT interventi.INT_SEQ,INT_DATA,id_tipo_operatore,note,prestazioni.PRE_NOMPRE,COUNT(INT_DATA) AS conta ,INT_NOMPAZ,PAZ_COGNOME,PAZ_NOME,id_paziente,approvato,CONCAT(PAZ_COGNOME,' ',PAZ_NOME) AS paziente,eseguito,SUM(durata+durata_aggiunta)+IF(aggiunta is Null,'0',aggiunta) AS durat,(SUM(durata+durata_aggiunta)+IF(aggiunta is Null,'0',aggiunta))/60 AS durath,id_richiesta_asl,GROUP_CONCAT(if(eseguita=1,CONCAT('',PRE_CODPRE,''),CONCAT('',PRE_CODPRE,''))) AS prest,DATE_FORMAT(INT_DATA,'%d-%m-%Y') AS dataint,OPE_COGNOME,OPE_NOME,approvato,CONCAT(OPE_COGNOME,' ',OPE_NOME) AS operatore,IF(eseguito='1' AND bb_ts_inizio Is Not Null,DATE_FORMAT(interventi.ts_aggiornamento,'%H:%i'),'') AS ora_chiusura,IF(eseguito=1,TIMESTAMPDIFF(MINUTE,bb_ts_inizio,bb_ts_fine),'') AS tempoimp,'Chiudi' AS ch,'Clona' AS clon,PAZ_DISTRE FROM ((((`tabella interventi` AS interventi INNER JOIN tabella_pazienti ON interventi.id_paziente=tabella_pazienti.id) INNER JOIN operatori ON interventi.id_operatore=operatori.id) INNER JOIN interventi_prestazioni ON interventi.INT_SEQ=interventi_prestazioni.id_intervento) INNER JOIN prestazioni ON interventi_prestazioni.id_prestazione=prestazioni.id) LEFT JOIN interventi_aggiunta ON interventi_aggiunta.id_intervento=interventi.INT_SEQ WHERE 1=1 AND INT_DATA>='2013-09-09' AND INT_DATA<='2013-09-09' AND ( LCASE(interventi.INT_DATA) >= '2013-09-09' AND LCASE(interventi.INT_DATA) <= '2013-09-09' )GROUP BY INT_DATA,id_paziente,id_operatore,INT_SEQ ORDER BY INT_DATA ASC, id_paziente ASC, interventi.id_operatore ASC, INT_SEQ ASC LIMIT 0, 50