Please help me to write a query (Date)

[vinnuk3]

Hi,
You can try this. Hope this solution fills u r requirements.

SELECT TO_CHAR(TO_DATE('01-JAN-2001','DD-MON-YYYY') + (ROWNUM - 1),'dd-MON-YYYY') new_date
FROM ALL_OBJECTS
WHERE TO_DATE('01-JAN-2001','DD-MON-YYYY') + (ROWNUM - 1) <=
TO_DATE('16-MAY-2001','DD-MON-YYYY');


Thanks & Regards
Vinod Kumar K