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

From: ajvctrindade <ajvctrindade_at_netcabo.pt>
Date: Tue, 1 Feb 2005 12:17:08 -0000
Message-ID: <129D379A6946B54E8384104F478CCCBB0A91E88B@VS1.hdi.tvcabo>

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_at_freelists.org em nome de ajvctrindade=20
	Enviada: ter 01-02-2005 12:00=20
	Para: zoran_martic_at_yahoo.com; sanjay.khangarot_at_wipro.com; =
oracle-l_at_freelists.org=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_at_freelists.org em nome de Martic Zoran=3D20
	        Enviada: ter 01-02-2005 10:45=3D20
	        Para: sanjay.khangarot_at_wipro.com; oracle-l_at_freelists.org=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_at_wipro.com 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_at_wipro.com

	        > 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

Received on Tue Feb 01 2005 - 07:19:45 CST