/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 votes200 views1 answer
Oracle nls session
SQL
0 vote232 views1 answer
How to add unique key constraint in mysql
SQL
-1 vote324 views5 answers
Left join sql
SQL
1 vote209 views2 answers
Mssql show database size
SQL
2 votes237 views1 answer
Select from array in psql
SQL
0 vote199 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote267 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote202 views2 answers
Sql join on wildcard
SQL
0 vote207 views1 answer
Change magento database url usimg musql
SQL
0 vote232 views1 answer
Mysql get hour from datetime
SQL