/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

0 vote143 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote153 views1 answer
SqlFunction does not exist
SQL
8 votes116 views1 answer
Similarities between ddl and dml
SQL
8 votes146 views1 answer
Sql limit results returned
SQL
0 vote172 views2 answers
Insert data mysql with cmd
SQL
0 vote156 views1 answer
Automatically update database last seen datetime in sql
SQL
17 votes207 views2 answers
How to assign date field for table in mysql
SQL
0 vote140 views1 answer
View acl table oracle
SQL
33 votes152 views6 answers
Change column name in mysql
SQL
13 votes146 views2 answers
Display users in mysql
SQL