# RE: How can I get the DD,MM, YYYY part of the every day in a duration of 10 years

• From: "ajvctrindade" <ajvctrindade@xxxxxxxxxx>
• To: <zoran_martic@xxxxxxxxx>, <sanjay.khangarot@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
• Date: Tue, 1 Feb 2005 12:17:08 -0000

```Hello,
=20
I already made it. Like this:
=20
select to_date(:starting_date_minus_one,'DD MM YYYY') + rownum

from xxx

where rownum <=3D :number_of_days

=20
=20
Thanks,
Trindade

-----Mensagem original-----=20
De: oracle-l-bounce@xxxxxxxxxxxxx em nome de ajvctrindade=20
Enviada: ter 01-02-2005 12:00=20
Para: zoran_martic@xxxxxxxxx; sanjay.khangarot@xxxxxxxxx; =
oracle-l@xxxxxxxxxxxxx=20
Cc:=20
Assunto: RE: How can I get the DD,MM, YYYY part of the every day in a =
duration of 10 years
=09
=09

Hello,
=3D20
I did try that with no sucess.
=3D20
Can you explain me better please?
=3D20
Thanks,
Ant=3DF3nio Trindade
=09
-----Mensagem original-----=3D20
De: oracle-l-bounce@xxxxxxxxxxxxx em nome de Martic Zoran=3D20
Enviada: ter 01-02-2005 10:45=3D20
Para: sanjay.khangarot@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx=3D20
Cc:=3D20
Assunto: Re: How can I get the DD,MM, YYYY part of the every =
day in a =3D
duration of 10 years
=3D09
=3D09
=09
Hi Sanjay,
=3D09
Something like this should do it for you
=3D09
select to_date(:1,'DD MM YYYY') + rownum
from xxx,xxx
where rownum < (:2 - :1)
=3D09
You need to replace :1 and :2 as binds for your dates.
=3D09
Will cover up to 1M days.
xxx is just a table with 1000 rows from 1 to 1000.
=3D09
Regards,
Zoran
=3D09
--- sanjay.khangarot@xxxxxxxxx wrote:
=3D09
> Hi,
> I want to generate one script which can return me
> dd,mm , yyyy part of every day for a duration, for
> example ..
> if I start from Jan 01,1999 to jan 01, 2010 then
> wanted the record for every day..
> 01 01 1999
> 02 01 1999
> ....
>
> till
> 01 01 2010..
>
> this will be used to create one time dimension..
>
> TIA
>
> Regards
>
> Sanjay
>
>
>
>
>
> Confidentiality Notice
>
> The information contained in this electronic message
> and any attachments to this message are intended
> for the exclusive use of the addressee(s) and may
> contain confidential or privileged information. If
> you are not the intended recipient, please notify
> the sender at Wipro or Mailadmin@xxxxxxxxx
> immediately
> and destroy all copies of this message and any
> attachments.
> --
> http://www.freelists.org/webpage/oracle-l
>
=3D09
=3D09
=3D09
=3D20
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
http://www.freelists.org/webpage/oracle-l
=3D09
=09
--
http://www.freelists.org/webpage/oracle-l
=09

--
http://www.freelists.org/webpage/oracle-l
```