/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 vote304 views1 answer
Use mysql in java program
SQL
0 vote261 views1 answer
Price-colour
SQL
1 vote267 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote332 views1 answer
Mysql get nested records
SQL
4 votes281 views1 answer
Group by mysql and concatenate string
SQL
0 vote275 views1 answer
How to add more columns to a table in mysql
SQL
0 vote280 views1 answer
Create tables from xsd to sql server database c#
SQL
3 votes309 views5 answers
No module named 'MySQLdb'
SQL
0 vote254 views1 answer
Oracle right characters
SQL
0 vote260 views1 answer
Difference between 2 query results sql server
SQL