/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 vote250 views1 answer
For row in sql database python loop
SQL
1 vote210 views1 answer
Show indices in mysql table
SQL
6 votes236 views3 answers
Commit in sql
SQL
50 votes251 views4 answers
Sql alter type of column
SQL
0 vote213 views1 answer
How to check if there is no database schema
SQL
2 votes267 views1 answer
Oracle find constraints referencing a table
SQL
10 votes249 views2 answers
Select nextval from sequence oracle
SQL
0 vote230 views1 answer
Oracle archivelog usage
SQL
2 votes229 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote233 views1 answer
Regex any word except sql
SQL