/SQL/Oracle convert run duration to number

Oracle convert run duration to number

-- Duration between 2 timestamps
SELECT (extract(DAY FROM TIME2 - TIME1) * 24 * 60 * 60) 
           + (extract(HOUR FROM TIME2 - TIME1) * 60 * 60) 
           + (extract(MINUTE FROM TIME2 - TIME1) * 60) 
           + extract(SECOND FROM TIME2 - TIME1)
FROM DUAL;

Source: stackoverflow.com

Similar codes

0 vote417 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote365 views1 answer
Full outer join in mariadb mysql
SQL
0 vote321 views1 answer
Mysql date + 1 day
SQL
25 votes348 views5 answers
Uninstall mysql ubuntu
SQL
0 vote363 views1 answer
Every Derived yable must have its own alias
SQL
0 vote351 views1 answer
How to find columns with null values in sql
SQL
2 votes414 views1 answer
Create delete procedure mysql
SQL
0 vote397 views1 answer
Having all mysql
SQL
4 votes425 views1 answer
Oracle table statistics
SQL
0 vote360 views1 answer
Mysql isshow
SQL