|
Re: How to get all dates between two dates in Oracle? [message #9763 is a reply to message #9762] |
Wed, 03 December 2003 16:01 |
Art Metzer
Messages: 2480 Registered: December 2002
|
Senior Member |
|
|
SQL> SET VERIFY OFF
SQL> SELECT TO_CHAR(TO_DATE('&&date_1','DD-MON-YYYY') + ROWNUM - 1,'DD-MON-YYYY') dt
2 FROM sys.all_objects
3 WHERE ROWNUM <= TO_DATE('&&date_2','DD-MON-YYYY')
4 -
5 TO_DATE('&&date_1','DD-MON-YYYY')
6 +
7 1
8 /
Enter value for date_1: 25-FEB-2004
Enter value for date_2: 03-MAR-2004
DT
-----------
25-FEB-2004
26-FEB-2004
27-FEB-2004
28-FEB-2004
29-FEB-2004
01-MAR-2004
02-MAR-2004
03-MAR-2004
8 rows selected.
SQL> HTH,
A.
|
|
|
|
|