Thursday, February 14, 2008

Ranges of Dates

In order to fill the range between 2 dates use the following query

select to_date('01/04/2008','DD/MM/YYYY')+rownum -1 dt
from user_tables
where rownum <= (to_date('01/05/2008','DD/MM/YYYY') - to_date('01/04/2008','DD/MM/YYYY'));

Fills dates from 01/04/2008 to 30/04/2008 !!!!

No comments:

Post a Comment