SQL Select statement / Time & date question

Hi.

Is there a way in SQL statement to count the number of records that updated per hour?

For example, a table with these fields and records:

trans_id       trans_date
---------     ------------
1               1/15/2004 12:18:33 PM
2               1/15/2004 2:07:01 PM
3               1/15/2004 2:10:12 PM

I need my report to say:

hour        num_of_trans
----         --------------
12 PM    1
2 PM      2

Any hints?

THANKS! Joe Received on Fri Jan 16 2004 - 08:20:14 CST