/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 vote221 views1 answer
Show the colums of table sql
SQL
0 vote203 views2 answers
Sql join on comma separated field
SQL
0 vote204 views2 answers
How to generate a unique random number in mysql
SQL
-1 vote164 views1 answer
How to create script to connect to oracle database and run query
SQL
10 votes205 views1 answer
Oracle all_dependencies
SQL
0 vote211 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote209 views1 answer
Sqlcl format
SQL
0 vote223 views1 answer
Sql gather statistics to increase performance
SQL
0 vote200 views1 answer
How to retrive the today date sql
SQL
16 votes200 views6 answers
Insert sql
SQL