Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between 2 timestamps in seconds

226982Aug 17 2009 — edited Oct 15 2012

Can anyone tell me how to subtract 2 timestamps and
get the difference in seconds? "extract" doesn't work,
it always gives a value between 0-59, I want the total
seconds, not the seconds part of the interval.

I'm using Oracle Database 10g Express Edition Release 10.2.0.1.0

This post has been answered by sb92075 on Aug 18 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2012

Added on Aug 17 2009

#general-database-discussions

7 comments

74,058 views