/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

-2 votes327 views3 answers
Oracle tablespace usage
SQL
0 vote354 views1 answer
What alter does in db
SQL
6 votes389 views2 answers
Oracle trigger
SQL
1 vote350 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote364 views2 answers
Postgres cast as decimal
SQL
2 votes333 views1 answer
Sql create database
SQL
3 votes338 views2 answers
Sql select data from last week
SQL
0 vote331 views1 answer
Postgres data location
SQL
0 vote333 views2 answers
Transaction php
SQL
5 votes375 views2 answers
Functions
SQL