Erol Çimen's ORACLE BLOG
Friday, June 1, 2012
How to list of dates between 2 dates
How to list of dates between 2 dates
select to_date('23-04-2011', 'DD-MM-YYYY') + rownum -1 dt
from dual
connect by level <= to_date('05-05-2011', 'DD-MM-YYYY') - to_date('23-04-2011', 'DD-MM-YYYY') + 1;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment