Group by HOUR? Is it possible? 1

[Rmcta]

I need to count how many records I have per hour.
Example of my time field:
5:26:46 PM
12:38:28 PM
10:38:16 AM

How do I do that?
I need to know how many record I have from 6 to 8 am and then from 8 to 9 am ..and so on.

Thank you very much

 

[mpastore]

I assume you have a date/time field:

select hour([mydatetime]),count(*)
from mytable
group by hour([mydatetime])

Note: hours after 12PM will be in military format, e.g. 10PM is 22, etc.

Mike Pastore

Hats off to (Roy) Harper

 

[Rmcta]

You are GREAT! Thank you very, very much