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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

208 views