SQL & PL/SQL

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!

Calculating elapsed interval between two datetime fields

user4030266Oct 13 2010 — edited Oct 13 2010

Hi,

I want to calculate elapsed second between two dates. How can I calculate this?

For ex. my table has two date columns like LAST_LOGIN_DATE and LAST_MESSAGE_SEND_DATE.
I want to find elapsed seconds ( as numbers) between last login date and last message send date.

How can I do this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2010

Added on Oct 13 2010

#date

3 comments

217 views