Oracle duration between timestamps

-- 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 vote336 views1 answer
Raiserror nowait sql server
SQL
0 vote379 views1 answer
Show all sequences postgres
SQL
0 vote379 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote352 views1 answer
Restore backupfile discourse
SQL
0 vote370 views1 answer
Add mysql database to power bi web
SQL
0 vote307 views1 answer
How to set field to null in sql
SQL
0 vote376 views1 answer
Second Step in installing SQL workbench
SQL
0 vote339 views1 answer
Pl/sql loop example
SQL
0 vote339 views1 answer
Ora 00001 error catch plsql
SQL
0 vote364 views2 answers
How to login to mysql as normal user in ubuntu
SQL