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

25 votes170 views6 answers
How to change column name in mysql
SQL
0 vote170 views1 answer
Codigo crear tablas sql server
SQL
13 votes144 views4 answers
Mysql select last 10 rows
SQL
26 votes147 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote145 views1 answer
Postgre admin slow
SQL
0 vote150 views1 answer
Less than date query sqlachemy
SQL
2 votes155 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote160 views1 answer
Search In the Data using ObjectName
SQL
0 vote186 views1 answer
Sql count matching group by
SQL
0 vote138 views1 answer
Psql check if value in array
SQL