DB2 V7.2 FP9 , AIX

select * from sn2

TS VAL
-------- -----------
17:13:48 8
17:14:03 10
17:14:09 15

3 record(s) selected.


I'm looking at getting a result like :

TSDIFF VALDIFF
---------------------
15 2
6 5

TSDIFF 15 is 17:14:03 - 17:13:48 seconds and the corresponding VALDIFF 2 is 10-8 ...

Can anyone help, please ?

BTW, I have quoted a simple thing with one column(other than timestamp) ... Actually I will want to have about half-a-dozen columns like this ...


Sathyaram

If anyone is interested

http://dbforums.com/showthread.php?threadid=921672

Cheers

sathyaram