Timestamp as a result of Timestamp Difference

bavirisetty · #1 (**permalink**) 10-05-09, 01:01

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

rahul_s80 · #2 (**permalink**) 10-05-09, 02:00

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

Internet Services

Web Development

Digital Marketing

Consumer Tech