Hello,
I have a table that has several columns including 1 for date and 1 for time HHMMSS.
I would like to get a count of rows grouped by date and within a given time interval of say 5 minutes during a 24 hour period. Can somebody help?
Something like this
Count, Date, Time
1, 09/22/08,00-04
3, 09/22/08,05-09
11,09/22/08,10-14
.
.
.
.
Can somebody point me in the right direction?
Thank You!!
I have a table that has several columns including 1 for date and 1 for time HHMMSS.
I would like to get a count of rows grouped by date and within a given time interval of say 5 minutes during a 24 hour period. Can somebody help?
Something like this
Count, Date, Time
1, 09/22/08,00-04
3, 09/22/08,05-09
11,09/22/08,10-14
.
.
.
.
Can somebody point me in the right direction?
Thank You!!