/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 vote230 views2 answers
Sql count number of rows after group by
SQL
6 votes219 views2 answers
Drop foreign key
SQL
3 votes240 views1 answer
Stpop start psql server
SQL
3 votes220 views2 answers
WhereIn SQL
SQL
1 vote247 views1 answer
Isnull sql server
SQL
1 vote232 views1 answer
Drop df constraint sql server
SQL
2 votes244 views1 answer
Sqlite3 show columns name
SQL
0 vote243 views1 answer
Sql comand for removing data from table
SQL
1 vote230 views1 answer
How to delete a record from sqlite in android
SQL
0 vote233 views1 answer
Sql server datetime to string
SQL