Time difference between records

[Scott Johnson]

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?

[Hans Forbrich]

Scott Johnson wrote:
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?

1) Ain't going nowhere if you don't capture a 'modified date/time' stamp.

2) Different database version provide different capabilities to help here.

3) In 10g look up the time interval datatype, otherwise look up date
arithmetic, both in the SQL Reference manual.

[FredBear]

"Scott Johnson" <stj_spam@yahoo.com> a écrit dans le message de
news: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?

Just a hint:

select ticket#, diff
from (select ticket#,
time-lag(time) over (partition by ticket# order by time) diff
from mytable)
where diff is not null
/

Btw, don't cross/multipost, we read all the cdo groups.

--
Regards
Michel Cadot

[Clam entreprenur]

TIME - most priced commodity; early bird...
- depreciation in value for inventory overstock, new car out of the
door is starting depreciating in value
- comply to work order, job contract, efficiency operation meeting
time line
- sufficient time for head up in magnified problem???!!!????

Select All where Time(2004), do constructive competition, coordinated synergy
Connie Lam
conniemlam2002@yahoo.com
CLAM ENTREPRENURIAL RESEARCH