/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

5 votes131 views1 answer
Mysql select greater than yesterday
SQL
12 votes141 views4 answers
Mysql version query
SQL
0 vote159 views1 answer
What is default mysql database password in linux
SQL
2 votes132 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote133 views1 answer
Wherein mysql
SQL
6 votes121 views1 answer
Oracle rank() over (partition)
SQL
2 votes131 views1 answer
Oracle sql concatenate results into string
SQL
0 vote144 views1 answer
Where date major today mysql
SQL
0 vote143 views1 answer
Hour and minute between two datatime sql
SQL
0 vote132 views2 answers
Plsql regex match whole word
SQL