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 vote107 views1 answer
Suse start MySQL
SQL
0 vote110 views1 answer
Call rest api from postgresql
SQL
1 vote121 views1 answer
Table valued functions in sql
SQL
16 votes123 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote136 views5 answers
Right join
SQL
18 votes73 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote111 views1 answer
How to fix mysql stop unexpectedly
SQL
2 votes119 views2 answers
Sqlite_busy: database is locked
SQL
2 votes104 views1 answer
Sqlplus clear screen
SQL
0 vote112 views1 answer
Vbscript connect mssql
SQL