date math

From: <jeff.w.mcclure_at_ameritech.com>
Date: 1998/03/31
Message-ID: <6frru3$go9$1@nnrp1.dejanews.com>#1/1

Folks,

I have a couple of questions concerning the manipulation of date fields within sql. The applications tables contain several date fields (per record). These fields describe the beginning time and ending time for a given network event. Management would like to see some reports showing the amount of time (duration) of an individual event, as well as the average time an event takes. As it was put to me:

duration = end_time - begin_time (on a per record basis) avg = (end_time - begin_time)/#_of_events

How do I accomplish this in sql (PL/SQL)?

I am running 8.0.3 on Solaris 2.5

Any help would be greatly appreciated...

Jeff McClure
Specialist DB Analyst
Ameritech New Media
e-mail:jeff.w.mcclure_at_ameritech.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 31 1998 - 00:00:00 CST