/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

2 votes236 views2 answers
Checking data type in sql server
SQL
2 votes244 views1 answer
Scaffold npgsql net core
SQL
0 vote234 views1 answer
What is logical database schema
SQL
1 vote230 views1 answer
Sqlite create index
SQL
3 votes264 views2 answers
Sql add year to date
SQL
0 vote242 views1 answer
Sqlalchemy case insensitive like
SQL
4 votes272 views1 answer
Postgres delete last row
SQL
2 votes231 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote243 views1 answer
Oracle repeat_interval 5 minutes
SQL
2 votes249 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL