date, select // count per 10 minutes

From: Gerhard <>
Date: Wed, 3 Sep 2008 05:50:17 -0700 (PDT)
Message-ID: <>

for statistics i need to select the number of orders per 10 minutes.

So i want to do something like

   SELECT TRUNC(insert_date, '??'), COUNT(*)    FROM orders .... ;

But within the trunc-(or other data-based) function allowed Patterns are "HH" or "MI".

as workaround i use:

   SELECT TRUNC(insert_date,'HH') +
TRUNC(TO_CHAR(ord_close_dt,'MI'),-1)/(60*24), COUNT(*)

   FROM orders .... ;

Is there an easyer way to do the select?

Gerhard Received on Wed Sep 03 2008 - 07:50:17 CDT

Original text of this message