Generating list of days in a given time interval

From: "Nikhil G(dot) Daddikar" <ngd(at)celoxis(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Generating list of days in a given time interval
Date: 2001-11-05 05:17:25
Message-ID: 005e01c165b9$2d538d10$2c00a8c0@darkstar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Denis Bucher 2001-11-05 14:02:11 Possible to create a *really* virtual table ?
Previous Message knut.suebert 2001-11-04 17:03:06 Re: Recursive select