/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 votes273 views1 answer
Oracle insert or update
SQL
1 vote252 views2 answers
String to date postgres
SQL
0 vote267 views1 answer
Mysql limit order by
SQL
2 votes273 views1 answer
Sql OR
SQL
0 vote289 views1 answer
How to fetch data from database in sql
SQL
4 votes273 views2 answers
Dbms output
SQL
4 votes257 views1 answer
Change nls_date_format
SQL
0 vote256 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
2 votes264 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote463 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL