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:00:56 -0000
Message-ID: <129D379A6946B54E8384104F478CCCBB0A91E88A@VS1.hdi.tvcabo>

Hello,
=20
I did try that with no sucess.
=20
Can you explain me better please?
=20
Thanks,

   Ant=F3nio Trindade

	-----Mensagem original-----=20
	De: oracle-l-bounce_at_freelists.org em nome de Martic Zoran=20
	Enviada: ter 01-02-2005 10:45=20
	Para: 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

        Hi Sanjay,
=09

        Something like this should do it for you =09

	select to_date(:1,'DD MM YYYY') + rownum
	from xxx,xxx
	where rownum < (:2 - :1)
=09
	You need to replace :1 and :2 as binds for your dates.
=09
	Will cover up to 1M days.
	xxx is just a table with 1000 rows from 1 to 1000.
=09
	Regards,
	Zoran
=09
	--- sanjay.khangarot_at_wipro.com wrote:
=09


	> 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

	>

=09

=09
=09

	              =20
	__________________________________
	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

=09

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

Received on Tue Feb 01 2005 - 07:03:35 CST