/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 vote327 views1 answer
Sql server select value large text
SQL
0 vote311 views1 answer
Mysql money value
SQL
0 vote315 views1 answer
Oracle sql generate list of days
SQL
0 vote397 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote332 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote336 views1 answer
Into operator in sql
SQL
0 vote318 views1 answer
Get cpu details sql
SQL
13 votes349 views5 answers
Alter table query sql server change column
SQL
1 vote310 views1 answer
Sql select table header
SQL
0 vote309 views2 answers
Android sqlite tutorial for beginners
SQL