Hi,
select sysdate from dual;
This produces
26-DEC-2008
How do I get 1 hour intervals for a given date?.
The O/P should be someting like
start from 12/26/2008 12:00:00 AM & end at last 1 hour of the same date( i,e: sysdate - 1 * 60 / 24 / 60 )
i,e
Somthing like
(First)12/26/2008 12:00:00 AM
12/26/2008 01:00:00 AM
12/26/2008 02:00:00 AM
.
.
.
(last) 12/26/2008 03:45:00 PM ( Provided current time is 12/26/2008 04:45:00 PM )
First time interval will be date at 12:00:00 AM
Last time interval will be current time - last 1 hour.
Any ideas how to do this?.
I am actually need this to calculate the avg num of transactions for each hour of a particular date starting with 12:00:00 AM