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 vote150 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote143 views1 answer
Carbon mysql d m y to y-m-d
SQL
-1 vote118 views1 answer
Mysql case when multiple conditions
SQL
0 vote122 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote147 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote124 views1 answer
Psql lst trigger
SQL
0 vote155 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote134 views1 answer
Automated psql csv export script on windows
SQL
0 vote80 views2 answers
Delete query sql server
SQL
2 votes126 views1 answer
Compare date in sql
SQL