/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

5 votes197 views2 answers
To date oracle
SQL
0 vote197 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote226 views1 answer
Sql character index
SQL
2 votes198 views3 answers
Copy data from one table column to another table column in sql
SQL
14 votes198 views4 answers
Import database through command line
SQL
1 vote187 views4 answers
Postgres extract date from timestamp
SQL
2 votes188 views1 answer
Mysql sysdate - 1 day
SQL
0 vote264 views1 answer
Grant privileges mysql to database 1064
SQL
-1 vote187 views1 answer
Condition in orderby mysql
SQL
0 vote192 views1 answer
Rename constraint postgresql
SQL