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

0 vote205 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote159 views1 answer
Sqlalchemy existing database
SQL
1 vote313 views1 answer
Adding a check statement in sql
SQL
17 votes262 views4 answers
Mysql remove ubuntu
SQL
14 votes228 views3 answers
SQL trim
SQL
0 vote177 views1 answer
Import sql mysql ubuntu
SQL
1 vote249 views1 answer
Create index concurrently postgres
SQL
0 vote190 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote195 views1 answer
Sql shell psql cannot enter password
SQL
1 vote205 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL