/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 vote219 views1 answer
Mysql best varchar length size
SQL
9 votes207 views4 answers
Mysql set id auto increment
SQL
0 vote195 views1 answer
Get who is hired in february in sql
SQL
1 vote148 views1 answer
Athena query timestamp greater than
SQL
0 vote268 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
7 votes236 views1 answer
Sql disable safe mode
SQL
0 vote189 views1 answer
Copy value from one column to another postgres
SQL
0 vote187 views1 answer
Mysql subdate
SQL
0 vote194 views1 answer
Create table database in psql
SQL
2 votes232 views1 answer
Revokeprivileges mysql
SQL