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 vote114 views1 answer
Mysql Install Ubuntu with native password
SQL
2 votes112 views1 answer
Plsql block
SQL
3 votes123 views1 answer
Force using index plsql
SQL
0 vote130 views1 answer
Mysql url data type
SQL
2 votes125 views2 answers
Spring where to put the data sql
SQL
0 vote111 views1 answer
Search In the Database using Text
SQL
0 vote122 views1 answer
Difference between min and max date sql
SQL
4 votes148 views1 answer
Ms sql truncate table vs delete
SQL
0 vote124 views1 answer
Typeorm raw sql
SQL
3 votes116 views1 answer
Start mysql server by terminal in linux
SQL