| Array of date problem [message #370384] |
Thu, 16 September 1999 11:01  |
Armin Theis
Messages: 2
Registered: September 1999
|
Junior Member |
|
|
How can I achieve an amount of days between 2 Dates in a select statement. (e.g. 01/01/1999 and 01/10/1999)
The select statement should return 10 Rows
01/01/1999
01/02/1999
..
01/10/1999
I don't want temporay tables and I couldn't find a system table like sysdate for the calendar.
Is there an existing solution or any other idea?
|
|
|
|
| Re: Array of date problem [message #370386 is a reply to message #370384] |
Thu, 16 September 1999 12:03  |
hmg
Messages: 40
Registered: March 1999
|
Member |
|
|
my solution
select actual_date from (select to_date('08.05.1999','DD.MM.YYYY') + rownum - 1 actual_date from emp)
where actual_date <= TO_DATE('16.05.1999','DD.MM.YYYY');
instead of table emp you have to choose any table with a large amount of rows,
larger than maximum expected array size.
|
|
|
|
| Re: Array of date problem [message #370388 is a reply to message #370386] |
Fri, 17 September 1999 09:53 |
m a sivan
Messages: 34
Registered: July 1999
|
Member |
|
|
undef startdate
select to_date('&&startdate','DD-MM-YY') + n from ( select rownum-1 as n from user_objects,all_tab_columns where rownum Returns any generalized end and startdates
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
