/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 vote114 views1 answer
Stuff in sql server
SQL
0 vote151 views1 answer
Mysql where sum > 0
SQL
0 vote128 views1 answer
Amount of entries in a table psql
SQL
0 vote123 views1 answer
Postgres read table structure
SQL
4 votes163 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote191 views1 answer
Mysql update table from select on another table
SQL
11 votes141 views2 answers
Having keyword sql
SQL
0 vote113 views1 answer
Sql cross apply vs join
SQL
0 vote127 views1 answer
Contact mysql column field
SQL
5 votes130 views2 answers
Ranking functions in sql
SQL