Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Query: Counting records by Time Interval

SQL Query: Counting records by Time Interval

From: <timmyojo_at_gmail.com>
Date: Mon, 25 Jun 2007 07:45:05 -0700
Message-ID: <1182782705.156059.238380@q69g2000hsb.googlegroups.com>


I have a table that tracks Request and Response data coming in and out of a system from different systems. Easch transaction originates from an external system, comes into the serving system as a Request (RQST), is TimeStamped (RQST_TM) and a response is generated (RSPN) and the response is TimeStamped (RPSN) and sent to the client system. Some of the columns in the table are as follows:

ECTN           CHARACTER  12     NOT NULLABLE
TRX_TYPE   CHARACTER   3      NOT NULLABLE
RQST           VARCHAR      600   NOT NULLABLE
RQST_TM     TIMESTAMP   10     NOT NULLABLE
RSPN           VARCHAR      600   NULLABLE
RSPN_TM     TIMESTAMP   10     NULLABLE
ORIG_CD      CHARACTER   2      NOT NULLABLE

I need to be able to view the number of requests (COUNT) that come in by hour intervals (for example between the hours of 8 and 9am, 9 and 10 am, 10 and 11am, etc) for a particular day and the peak time period the system recieves requests. Could someone help me?

Thanks,
Tim Received on Mon Jun 25 2007 - 09:45:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US