SQL to group data by Day

[SDB]

sorry guys, I missed this..

Yeah, I had a quick play, realised that, as you say it grouped by day of the month, so just added year and month fields, and sorted by them as well.

Thank to both

-

For anyone reading this and still struggling, use :

year(from_unixtime(timestamp_field)) as year, month(from_unixtime(timestamp_field)) as month, day(from_unixtime(timestamp_field)) as day...

then

group by year, month, day
order by year, month, day