/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 vote322 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
-1 vote288 views1 answer
Sql add column bit
SQL
58 votes520 views4 answers
Mysql drop column
SQL
5 votes297 views1 answer
Postgresql functions
SQL
-1 vote265 views1 answer
How to format tables in sqlplus
SQL
0 vote306 views1 answer
Oracle change password expiration policy
SQL
0 vote278 views1 answer
Django mysqlclient connection string
SQL
3 votes338 views1 answer
What is having
SQL
0 vote301 views1 answer
Soql update query
SQL
5 votes286 views2 answers
Mysql date greater than 30 days
SQL