/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 vote356 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote325 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote326 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote321 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote264 views1 answer
Oracle compile schema
SQL
0 vote339 views2 answers
How to login to mysql as normal user in ubuntu
SQL
1 vote301 views1 answer
SQLSTATE[HY000] [2002]
SQL
9 votes300 views3 answers
Mysql get last id
SQL
0 vote373 views1 answer
Drop view sql
SQL
0 vote308 views1 answer
Select row from mysql where date more than 30 days
SQL