/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 vote109 views1 answer
Date on SQL
SQL
-2 votes96 views1 answer
How to open database
SQL
0 vote97 views1 answer
Mysqldump ignore table
SQL
1 vote93 views1 answer
Mysql count all table rows
SQL
1 vote112 views2 answers
Oracle list service names
SQL
-1 vote131 views1 answer
Create view in mysql workbench
SQL
1 vote102 views2 answers
Postgres cast as decimal
SQL
3 votes104 views2 answers
Monthname sql
SQL
2 votes119 views3 answers
How do I add a user to a postgres database? cli
SQL
2 votes102 views1 answer
Set boolean flasksql
SQL