Group by date time in MySql

I create a field with date-time option like this

`scan_date` datetime DEFAULT NULL,

And I just know that we can grab date only partial by using date in sql statement. Try this:

SELECT avg(wqi), date(scan_date) dateOnly FROM `riverdata` group by dateOnly

:P

Trellis Desk: Free User-friendly help desk system

Trellis Desk is a powerful, robust help desk solution for your business. Improve your company's service by allowing your customers to quickly and easily submit support tickets to your team. Trellis Desk sports a range of advanced features to revitalize the way your business handles customer support. Even better, it's completely free; you don't have to pay any license fees to use Trellis Desk.