/SQL/Oracle convert run duration to number

Oracle convert run duration to number

-- 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

4 votes281 views3 answers
Is not null sql
SQL
0 vote340 views1 answer
Stop and start mysql
SQL
0 vote264 views1 answer
Turnicate in mysql
SQL
1 vote311 views1 answer
Db.Database.SqlQuery
SQL
0 vote304 views1 answer
Amount of entries in a table psql
SQL
0 vote292 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
3 votes275 views4 answers
Stop MySQL
SQL
0 vote280 views1 answer
Sql get date from timestamp
SQL
9 votes298 views3 answers
Date format in sql
SQL
0 vote304 views1 answer
Psql check table fields
SQL