Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Time difference between records

Time difference between records

From: Scott Johnson <stj_spam_at_yahoo.com>
Date: Tue, 14 Sep 2004 10:49:57 -0400
Message-ID: <414702d0$0$26167$bb8e7a08@news.usenetcompany.com>


I need to find a method (sql, plsql) to find the time difference between records

Example,

Ticket#      Operation    Time
A1             Modify         1000
A1             Modify         1100
A1             Modify         1300
A2             Modify         0900
A2             Modify         0930

Should produce something like:

A1 1 hour
A1 2 hours
A2 30 minutes

Has anyone done this before? Received on Tue Sep 14 2004 - 09:49:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US