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

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Tue, 1 Feb 2005 02:45:20 -0800 (PST)
Message-ID: <20050201104520.97961.qmail@web52602.mail.yahoo.com>

Hi Sanjay,

Something like this should do it for you

select to_date(:1,'DD MM YYYY') + rownum from xxx,xxx
where rownum < (:2 - :1)

You need to replace :1 and :2 as binds for your dates.

Will cover up to 1M days.
xxx is just a table with 1000 rows from 1 to 1000.

Regards,
Zoran

• sanjay.khangarot_at_wipro.com wrote:

> 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
>
                

---

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

Received on Tue Feb 01 2005 - 05:47:55 CST