select * from tabella where date(campo_datetime) = '2007-07-23'