/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 vote138 views1 answer
Get table which have specific columns in mysql
SQL
0 vote137 views1 answer
Compare subqueries oracle
SQL
3 votes137 views2 answers
Mysql create timestamp column
SQL
1 vote190 views1 answer
Sql comment header
SQL
1 vote154 views2 answers
Sql where is not number
SQL
14 votes133 views3 answers
Delete all records from table except sql
SQL
-2 votes145 views1 answer
Modify column name in tsql
SQL
8 votes130 views3 answers
Duplicate entry
SQL
0 vote151 views2 answers
How to get max from each department in sql
SQL
0 vote91 views1 answer
Deleted table in sql trigger
SQL