/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

3 votes323 views1 answer
Select table column in sql
SQL
1 vote298 views1 answer
Mysql get last insert id
SQL
1 vote339 views3 answers
Union in sql
SQL
0 vote328 views1 answer
Postgresql default value boolean
SQL
5 votes377 views1 answer
Oracle source query
SQL
2 votes348 views2 answers
Storing timezones in postgres
SQL
4 votes331 views1 answer
Id primary key auto generated
SQL
0 vote346 views1 answer
Calculate age in sql
SQL
0 vote311 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote308 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL