|
|
|
Re: Event Count [message #339748 is a reply to message #339458] |
Fri, 08 August 2008 06:27   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
This should give you a good pointer as to how to group the dates into 5 minute sections:with src as (select sysdate + (level/(24*60)) dte from dual connect by level <= 300)
select to_char(dte,'dd.mm.yyyy hh24:mi:ss') actual_date
,to_char(trunc(dte) + (to_number(to_char(dte,'SSSSS'))-mod(to_number(to_char(dte,'SSSSS')),(5*60)))/(24*60*60),'dd.mm.yyyy hh24:mi:ss') five_min_date from src;
|
|
|
Re: Event Count [message #339773 is a reply to message #339748] |
Fri, 08 August 2008 07:44  |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
JRowbottom wrote on Fri, 08 August 2008 07:27 | This should give you a good pointer as to how to group the dates into 5 minute sections
|
[ Evil grin ]
I have a feeling the OP head just exploded, as it took me a while to figure it out.
[ /Evil grin ]
|
|
|