/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 vote360 views1 answer
The package java.sql is not accessible
SQL
0 vote208 views1 answer
Postgresql regular expression special characters
SQL
1 vote188 views1 answer
Alter table column size oracle
SQL
-1 vote196 views3 answers
My sql alter table
SQL
1 vote201 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote202 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote188 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote187 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
5 votes192 views2 answers
Oracle timestamp to date
SQL
0 vote247 views1 answer
Copy row from db to db mysql
SQL