/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

1 vote182 views1 answer
Error code 1292 mysql workbench
SQL
0 vote193 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote242 views1 answer
Php insert null mysql
SQL
0 vote178 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
-1 vote197 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote199 views1 answer
Systems sql
SQL
2 votes235 views3 answers
How to replace null values in sql
SQL
0 vote183 views2 answers
Mysql multiply
SQL
0 vote210 views1 answer
Mysql get hour from datetime
SQL
16 votes181 views2 answers
Mysql date between two dates
SQL