Answers for "oracle list days between two dates"

SQL
5

oracle list days 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;
Posted by: Guest on July-13-2021
0

oracle difference between two dates in days

  v_numvar := dt1-dt2;
Posted by: Guest on July-20-2020

Code answers related to "oracle list days between two dates"

Code answers related to "SQL"

Browse Popular Code Answers by Language