/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

1 vote155 views2 answers
Sql server concat string and int
SQL
2 votes142 views2 answers
Join update query in sql
SQL
0 vote144 views2 answers
Check mysql timezone
SQL
1 vote138 views1 answer
How to between in sql
SQL
0 vote182 views1 answer
Mysql 3 months ago
SQL
10 votes149 views4 answers
Primary key sql
SQL
22 votes153 views3 answers
How to join three tables in sql using joins
SQL
0 vote136 views1 answer
Oracle tablespace autoextend
SQL
1 vote154 views1 answer
SQL Integer devision
SQL
11 votes176 views2 answers
Mysql disable safe mode
SQL