Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    4

    Unanswered: Timestamp as a result of Timestamp Difference

    I would like to get a timestamp as a result after calculating difference between two timestamps.

    For example: timestamp - 13 months in terms of a timestamp

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    you can get that in decimal format
    db2 " select ( timestamp('2009-10-05-01.52.54.434868') - timestamp('2009-10-04-03.51.03.105198') ) from dual "

    > 220151.329670

    >> 22 hrs , 1 min, 51 sec and 329670 microsecs
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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