/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

-1 vote128 views5 answers
Not in sql
SQL
4 votes143 views1 answer
T-sql get duplicate rows
SQL
0 vote135 views2 answers
Sql query for getting details by id
SQL
1 vote120 views1 answer
Round function in sql oracle
SQL
0 vote166 views1 answer
Compare strings lexicographically in sql
SQL
0 vote183 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote132 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote137 views2 answers
Find lowest number in sql
SQL
0 vote132 views2 answers
Postgresql get last day of month
SQL
1 vote139 views1 answer
Flask sqlalchemy default value
SQL