/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

1 vote146 views1 answer
Mysql select update same table
SQL
9 votes168 views3 answers
Sequence postgresql
SQL
2 votes140 views2 answers
Select multiple tables mysql
SQL
3 votes148 views2 answers
Monthname sql
SQL
0 vote167 views1 answer
Oracle swap partition
SQL
3 votes178 views5 answers
Duplicate table sql
SQL
0 vote151 views1 answer
Rename view mysql
SQL
1 vote209 views1 answer
Mysql stop password policy
SQL
3 votes181 views1 answer
RENAME table pl sql
SQL
0 vote139 views1 answer
Soql more than today
SQL