/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 vote94 views1 answer
Google sheets filter rows above current cell
SQL
0 vote96 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote87 views1 answer
How to find top 3 salary in sql
SQL
0 vote97 views1 answer
Sql select by content lenght
SQL
6 votes88 views4 answers
Mysql update set
SQL
7 votes108 views1 answer
Grant schema permissions postgres
SQL
0 vote113 views1 answer
Plpgsql create function
SQL
0 vote103 views1 answer
How to find database collation in postgres
SQL
1 vote106 views2 answers
Logical operators in sql
SQL
0 vote91 views1 answer
Sqldf change user
SQL