select count(PK) Count, DatePart(hh,ColumnTime) Hour from dbTable group by DatePart(hh,dbColumnTime)

// Try this: DateTime now   = DateTime.Now; DateTime date = new DateTime(now.Year, now.Month, now.Day);

You can do it sql by using 'DatePart(ms,<dbColumnTime>)' function

--You can use 'set' instead of 'select' declare @t as DateTime set @t = getUtcDate() -- Testing-- print @t print DatePart(hh,@t) print DatePart(mm,@t) print DatePart(ss,@t) print DatePart(ms,@t)