Re: date math

Try this:

select end_time - begin_time from ________;

and

select avg(end_time - begin_time) from ________-;

jeff.w.mcclure_at_ameritech.com wrote:
>
> 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