Oracle all dates between two dates

-- All dates between 01/01/2021 and 15/01/2021
SELECT to_date('01/01/2021', 'DD/MM/YYYY') + ROWNUM - 1
FROM ALL_OBJECTS
WHERE ROWNUM <= to_date('15/01/2021', 'DD/MM/YYYY') 
	- to_date('01/01/2021', 'DD/MM/YYYY') + 1;

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

4 votes192 views1 answer
Force drop all tables postgres
SQL
0 vote199 views1 answer
Pl sql constraint user function
SQL
1 vote223 views1 answer
Oracle compile schema
SQL
0 vote203 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
6 votes243 views1 answer
Identify primary key in oracle table
SQL
1 vote279 views1 answer
Mysql show database size in mb
SQL
0 vote211 views1 answer
Get id if is not equal in certain table
SQL
-1 vote208 views1 answer
Ssql to lowercqse
SQL
13 votes228 views1 answer
Sql join 3 tables on id
SQL
2 votes197 views1 answer
Install sqlite npm
SQL