I have timestamp as one of the fields and it's format is '09/29/1999 09:23:23AM'. the timestamp is in 10 minute intervals.

now, I have to group the data such that timestamp is in hourly interval.

for ex,

timestamp count abort
09/29/1999 08:53:23AM 2121 432

09/29/1999 09:03:23AM 242 4445

09/29/1999 09:13:23AM 5353 646
....


should appear as


timestamp count abort
09/29/1999 09:00AM 66263 6464

09/29/1999 10:00AM 103833 493027

09/29/1999 11:00AM 391015 340202



and so on...

so all the data should be grouped(i.e totalled) under hourly interval

can someone let me know

thanks