/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 vote146 views3 answers
SQL MM/dd/yyyy format
SQL
123 votes306 views5 answers
Sql where contains
SQL
0 vote144 views1 answer
Mariadb hours between two dates
SQL
2 votes118 views1 answer
Sql column values comma separated
SQL
2 votes120 views1 answer
Compare date in sql
SQL
1 vote114 views1 answer
Scaffold mysql database
SQL
0 vote159 views1 answer
Oracle plsql sleep
SQL
1 vote123 views1 answer
Mysql last year
SQL
1 vote109 views1 answer
Oracle check table space
SQL
0 vote139 views2 answers
Get value from a table an insert it with other values in another table sql
SQL