/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 vote186 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote193 views1 answer
How to get data from 2 database
SQL
0 vote179 views3 answers
CONTACT FORM SQL
SQL
0 vote216 views1 answer
Get total and distict row diff in sql
SQL
-2 votes194 views1 answer
Trunc in sql
SQL
1 vote178 views1 answer
Best sql course
SQL
0 vote184 views1 answer
Difference between min and max date sql
SQL
1 vote193 views1 answer
Postgresql substring last
SQL
1 vote186 views1 answer
Sql how to duplicate a table
SQL
0 vote186 views1 answer
What is between keyword used for
SQL