/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

32 votes184 views6 answers
Insert select
SQL
8 votes180 views1 answer
Oracle find text in functions
SQL
0 vote172 views1 answer
Mysql percentage of total
SQL
0 vote207 views1 answer
Hallo
SQL
0 vote179 views1 answer
Mysql workbench format date
SQL
0 vote218 views1 answer
Mysql last friday of current month
SQL
0 vote182 views1 answer
Grant privileges of databse to user
SQL
7 votes179 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote182 views1 answer
Sql: extract day text from datetime value
SQL
0 vote186 views1 answer
Run sql script file and changes db name in this file using c#
SQL