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 vote202 views1 answer
Logtash mysql cofiguration file
SQL
0 vote184 views2 answers
Update information in a mysql column
SQL
9 votes226 views3 answers
Sequence postgresql
SQL
0 vote206 views1 answer
Sql server change schema of a table
SQL
0 vote198 views1 answer
Set a default value for a column in sqlite
SQL
2 votes207 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote208 views1 answer
Implicit inner join table alias
SQL
0 vote198 views1 answer
Oracle sql generate list of days
SQL
7 votes243 views1 answer
Alter sequence set current value oracle
SQL
4 votes213 views3 answers
Drop Table Oracle
SQL