/SQL/Oracle difference between two dates in seconds

Oracle difference between two dates in seconds

Oracle difference between two dates in years

select floor(months_between(date '2012-10-10', date '2011-10-10') /12) from dual;

select floor(months_between(date '2012-10-9' , date '2011-10-10') /12) from dual;

Source: stackoverflow.com

Oracle difference between two dates in seconds

SELECT (END_DT - START_DT) * 60 * 60 * 24 FROM MY_TABLE;   	-- Seconds
SELECT (END_DT - START_DT) * 60 * 24 FROM MY_TABLE;   		-- Minutes
SELECT (END_DT - START_DT) * 24 FROM MY_TABLE;   			-- Hours

Similar codes

0 vote153 views1 answer
What is mysql_pconnect
SQL
0 vote161 views1 answer
Select new table sql
SQL
13 votes149 views2 answers
Sql join
SQL
2 votes152 views2 answers
Sqlalchemy return id after insert
SQL
0 vote136 views1 answer
Sequelize postgresql schema
SQL
50 votes205 views6 answers
Sql duplicate rows
SQL
0 vote137 views1 answer
Sql composite key
SQL
1 vote145 views1 answer
Increasing font and zooming in mysql workbench
SQL
1 vote144 views1 answer
Alter add syntax
SQL
0 vote158 views1 answer
Connect to ssms with python
SQL