Home » RDBMS Server » Server Administration » Array of date problem
Array of date problem [message #370384] Thu, 16 September 1999 11:01 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: How to Pass array from oracle procedure and Get it?
Next Topic: Oracle API Urgent
Goto Forum:
  


Current Time: Wed Oct 21 11:21:03 CDT 2020