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

From: <arul.kumar_at_bt.com>
Date: Tue, 1 Feb 2005 10:43:27 -0000
Message-ID: <83FC2D1BC95D884894735B11B562A41C0A6EA30A@i2km06-ukbr.domain1.systemhost.net>

I could quickly think of a Pl/sql procedure with a for loop and dbms_output msgs... / INSERT the data into a table!!

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sanjay.khangarot_at_wipro.com
Sent: 01 February 2005 10:31
To: oracle-l_at_freelists.org
Subject: How can I get the DD,MM, YYYY part of the every day in a duration of 10 years

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

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 01 2005 - 05:45:04 CST