Received: from server2000.ebizhostingsolutions.com ([64.46.105.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA55FZq94578 for ; Mon, 5 Nov 2001 00:15:40 -0500 (EST) (envelope-from ngd@celoxis.com) Received: from [203.94.238.182] (helo=darkstar) by server2000.ebizhostingsolutions.com with asmtp (Exim 3.33 #1) id 160c5I-0006uu-00 for pgsql-sql@postgresql.org; Mon, 05 Nov 2001 00:14:09 -0500 Message-ID: <005e01c165b9$2d538d10$2c00a8c0@darkstar> From: "Nikhil G. Daddikar" To: Subject: Generating list of days in a given time interval Date: Mon, 5 Nov 2001 10:47:25 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server2000.ebizhostingsolutions.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [0 0] X-AntiAbuse: Sender Address Domain - celoxis.com X-Archive-Number: 200111/42 X-Sequence-Number: 5426 I would like to do the following: Input: start date, end date output: list of days between start date and end date Example: If input is: 2 Nov 2000, 3 Dec 2000, required output is 2 Nov, 3 Nov, 4 Nov, ... 3 Dec Thanks in advance! Nikhil