/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 vote343 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote325 views1 answer
Oracle archivemode
SQL
-1 vote338 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote348 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote351 views1 answer
Ubuntu connect to mssql database
SQL
0 vote353 views1 answer
Const pool = mysql.createpool()
SQL
0 vote342 views1 answer
Addition of 2 column value in mysql
SQL
0 vote351 views1 answer
Max mysql
SQL
14 votes361 views1 answer
Oracle alter table add column not null
SQL
1 vote354 views1 answer
How to unlock table in mysql
SQL