Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: SQL Query - How to ?

    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: SQL Query - How to ?

    If anyone is interested

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

    Cheers

    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •