group by in MySQL example only date from datetime

For ubuntu (i used ubuntu 12.04), the default phpmyadmin apache configuration can be found at /etc/phpmyadmin/apache.conf You can open it by type sudo nano /etc/phpmyadmin/apache.conf and change the third To restart apache service