/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

1 vote315 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
6 votes420 views2 answers
Oracle compile trigger
SQL
0 vote310 views1 answer
How to install Firebird
SQL
10 votes335 views1 answer
Oracle all_dependencies
SQL
0 vote333 views1 answer
RowDataPacket
SQL
2 votes342 views1 answer
Postgresql change value in column
SQL
0 vote339 views1 answer
How to check the port of mysql installation in mac
SQL
5 votes332 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote344 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote391 views1 answer
Sql basic commands
SQL