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

2 votes112 views2 answers
Mysql search for column name in all tables
SQL
0 vote149 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote94 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote107 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote119 views1 answer
Sql max of two values
SQL
0 vote104 views1 answer
Oracle current session details
SQL
4 votes140 views1 answer
Postgresql list sequences
SQL
5 votes103 views1 answer
JBDC
SQL
0 vote97 views1 answer
How to get data between a last week in mysql
SQL
0 vote55 views1 answer
Oracle sql developer script output limit
SQL