I have been asked to somehow compile the average number of hourly transactions for 12 months of data broken down into months (spannig a fiscal calendar). The time stamp in my db is AM PM formatted e.g. 12:01:44 AM. Thinking that somehow I need to do a count for each hour and divide by the appropriate number of days in that month to get an average...any ideas...
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Any guidance is greatly appreciated...groovymonkey