/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 vote378 views1 answer
Mysql streaming example
SQL
3 votes273 views2 answers
Mysql sum with condition
SQL
0 vote328 views1 answer
Drop procedure sql
SQL
0 vote358 views1 answer
Oracle list user locked
SQL
1 vote326 views1 answer
Mysql dump specific tables
SQL
2 votes318 views2 answers
Mysql date range
SQL
1 vote354 views2 answers
Sql insert timestamp
SQL
0 vote358 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote320 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote376 views2 answers
Drop table with constraints
SQL