Skip to Main Content
Forums

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!

Average of data with INTERVAL DAY(99) TO SECOND(99) datatype columns

818464Apr 11 2011 — edited Apr 11 2011
Hi All,
I am trying to get an average of the run_duration column in the SCHEDULERJOB_RUN_DETAILS oracle view (11g R2). The datatype for the run_duration column is INTERVAL DAY(3) TO SECOND(0).
How can we run mathematical functions (sum, avg, diff) on the columns with data types INTERVAL DAY(3) TO SECOND(0) or TIMESTAMP () WITH TIMEZONE ?

Thanks in advance
VB
This post has been answered by syakobson on Apr 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2011
Added on Apr 11 2011
5 comments
4,311 views