New answers tagged

3

Try: GROUP BY cast(StartTime as DATE) ORDER BY cast(StartTime as DATE); Grouping by the raw, unconverted value means you are guaranteed to have a row for every unique StartTime. (And it probably makes sense to sort that way, otherwise your rows could come back in an arbitrary and unintuitive order.)



Top 50 recent answers are included