/SQL/Oracle convert run_duration to number

Oracle convert run_duration to number

SELECT JOB_NAME,
       avg(extract(DAY FROM run_duration) * 24 * 60 * 60
               + extract(HOUR FROM run_duration) * 60 * 60
               + extract(MINUTE FROM run_duration) * 60
               + extract(SECOND FROM run_duration))
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE JOB_NAME = 'my_job_name'
GROUP BY JOB_NAME;

Source: thatjeffsmith.com

Similar codes

0 vote355 views1 answer
Consecutive numbers sql
SQL
0 vote297 views1 answer
Show all mongodb
SQL
1 vote306 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote316 views1 answer
How to group by month using sql server
SQL
0 vote345 views1 answer
Sql query to find percentage of null values in a table
SQL
10 votes309 views1 answer
Create table oracle
SQL
0 vote359 views1 answer
How to inner join 4 tables in sql
SQL
5 votes298 views3 answers
Truncate function in sql oracle
SQL
2 votes265 views2 answers
Mysql get last character of string
SQL
1 vote339 views5 answers
Postgresql difference between two dates in days
SQL