/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 vote273 views1 answer
Mysql docker image for macbook m1
SQL
-1 vote340 views1 answer
Difference berween database and data base management system
SQL
0 vote285 views1 answer
Sql delete row from table where id
SQL
0 vote291 views1 answer
Sp in sql server
SQL
13 votes261 views3 answers
Uninstall mysql centos 7
SQL
0 vote273 views1 answer
C# select Mysql
SQL
0 vote294 views1 answer
Sql declare variable single line
SQL
28 votes303 views4 answers
Delete database mysql
SQL
0 vote291 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote294 views1 answer
Convert polygon to text in mysql
SQL