List of Days between two dates in Oracle SQL
Hello,
You can use the following SQL Script in order to fetch list of days between two dates.
|
1 2 3 4 5 |
SELECT to_date('01.01.2014', 'dd.mm.rrrr') + LEVEL - 1, LEVEL FROM DUAL CONNECT BY LEVEL <= to_date('15.01.2014', 'dd.mm.rrrr') + 1 - to_date('01.01.2014', 'dd.mm.rrrr'); |
Result;
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
TO_DATE('01.01.2014','DD.MM.RRRR')+LEVEL-1 LEVEL ------------------------------------------ ---------- 01/01/2014 1 02/01/2014 2 03/01/2014 3 04/01/2014 4 05/01/2014 5 06/01/2014 6 07/01/2014 7 08/01/2014 8 09/01/2014 9 10/01/2014 10 11/01/2014 11 12/01/2014 12 13/01/2014 13 14/01/2014 14 15/01/2014 15 15 rows selected. |