Re: Date Difference

From: Ajay M Gandhi <agandhi_at_osf1.gmu.edu>
Date: 25 Jan 1995 19:46:39 GMT
Message-ID: <3g69qv$374_at_portal.gmu.edu>

Ajay M Gandhi (agandhi_at_osf1.gmu.edu) wrote:

: Tommy Wareing (p0070621_at_brookes.ac.uk) wrote:
: : In article <3feaqs$d47_at_portal.gmu.edu>, agandhi_at_osf1.gmu.edu (Ajay M Gandhi) says:

: : >Ajay M Gandhi (agandhi_at_osf1.gmu.edu) wrote:
: : >: Vince Cross (bartok_at_bnr.ca) wrote:
: : >: : Ajay M Gandhi <agandhi_at_mason1.gmu.edu> wrote:
: : >: : >Is there any function that can find the number of hours and
: : >: : >minutes between two date functions?

select to_char((trunc(24*(tim - event_date_time)))) || ':' ||

       ltrim(to_char((trunc(24*60*(tim - event_date_time)) -
             (60*trunc(24*(tim - event_date_time)))), '00')) || ':' ||
       ltrim(to_char((trunc(24*60*60*(tim - event_date_time)) -
             (60*trunc(24*60*(tim - event_date_time)))), '00'))

from your table;

Thanks to Dan kennedY

Ajay GandhI
SIRC
Fax :(703)-803-8930
e-mail : agandhi_at_gmu.edu

---

SIRC => Software Information Resource Corp. - Meeting Future Needs

---

Received on Wed Jan 25 1995 - 20:46:39 CET