+ Start a Discussion

Aggregate results to display

I have a requirement where i have displayed some Events between 2 different Date.
    But while i'm gona display them through pageblock table Group By StartDateTime, the query as follows is not suppoting 
    select Subject,StartDateTime,day_only(StartDateTime),EndDateTime,Owner.Name,CreatedDate, 
    from Event group by day_only(StartDateTime) 
Any body plz help to fix the error