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!

How to convert numtodsinterval to minutes?

yakub21Nov 4 2008

Thanks in advance.

I have a query for which I am checking the elapsed time to run a batch job.

select numtodsinterval(avg(Last_DATE_UPDATE - STARTDATE),'minutes') avg_time
from job_run where job_id = 'MMCD';

I get:
AVG_TIME
----------------------------------------
+0000000000 00:00:04.254901175
1 row selected.

How do I convert this to Minutes which could 100 or 20 or any number. I'm trying to get a whole number. Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2008

Added on Nov 4 2008

#general-database-discussions

0 comments

191 views