/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 vote314 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote337 views2 answers
Mysql update two tables at once
SQL
0 vote331 views1 answer
Sql last 3 rows
SQL
0 vote323 views1 answer
Remove binlog mysql
SQL
3 votes365 views5 answers
No module named 'MySQLdb'
SQL
0 vote352 views1 answer
Dataframe lambda elif
SQL
1 vote353 views1 answer
T-sql disable system versioning
SQL
0 vote352 views1 answer
Oracle sql developer closed connection
SQL
0 vote331 views1 answer
Pgsql is not permitted to log in
SQL
1 vote351 views1 answer
How to put value in variable mysql
SQL