/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

2 votes258 views1 answer
Q operator in oracle
SQL
4 votes225 views1 answer
Create column mysql terminal
SQL
0 vote244 views1 answer
Dbms_output sql developer
SQL
7 votes218 views1 answer
Forge server hosting
SQL
8 votes236 views1 answer
Database backup in mysql server recovery
SQL
0 vote236 views1 answer
Update if else mysql
SQL
0 vote249 views1 answer
Migrations.RunSQL
SQL
0 vote260 views1 answer
Selecting Multiple Columns in SQL
SQL
7 votes228 views2 answers
Sql server drop temp table if exists
SQL
-1 vote237 views1 answer
Sql set max value in column
SQL