/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

8 votes149 views3 answers
Connect python to mysql
SQL
13 votes141 views6 answers
Restart postgresql
SQL
0 vote156 views1 answer
How to find lowest in sql
SQL
0 vote159 views1 answer
Sql select column name like from multiple tables
SQL
0 vote141 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote155 views1 answer
Sqlalchemy one column of two has to be not null
SQL
3 votes147 views1 answer
Sql case update
SQL
11 votes150 views1 answer
Mysql text type max length
SQL
0 vote105 views1 answer
Mysql date + 1 day
SQL
0 vote157 views1 answer
Download sql file of countries names
SQL