/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 vote205 views1 answer
Null column as zero in mysql
SQL
1 vote201 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote205 views1 answer
T sql cursor tr
SQL
0 vote187 views1 answer
Drop all tables in azure sql database
SQL
0 vote240 views1 answer
Sql tablo hangi sp de
SQL
7 votes199 views1 answer
Minecraft forge server host
SQL
0 vote199 views1 answer
Postgresql delete limit
SQL
6 votes195 views4 answers
Sqlite drop table
SQL
0 vote189 views1 answer
Strat with in sql
SQL
4 votes200 views2 answers
How to count items with same name in sql
SQL