How to select the average between dates
511874Jun 13 2008 — edited Jun 17 2009I would like to obtain the average between two date columns in the current month.
This is my table
create table test (start_date date, end_date date, id number);
Then I have inserted
insert into test values (sysdate, sysdate+30/1440, 1);
insert into test values (sysdate, sysdate+30/1440, 2);
insert into test values (sysdate, sysdate+30/1440, 3);
insert into test values (sysdate, sysdate+30/1440, 4);
I would like to obtain the average (30minutes) for this month.
How can I do it?