/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

14 votes117 views3 answers
SQL trim
SQL
0 vote119 views1 answer
Postgresql remove new line from string
SQL
0 vote153 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote133 views1 answer
What is delimiter in mysql
SQL
0 vote129 views1 answer
Dockerfile example for Django
SQL
0 vote109 views1 answer
Check index sql server
SQL
1 vote117 views1 answer
Tsql find foreign key references
SQL
1 vote115 views1 answer
Sql get missing id
SQL
0 vote126 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote101 views1 answer
Alter table myisam to innodb
SQL