Query to find list of dates between two dates

From: aravind chandu <avin_friends(at)yahoo(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Query to find list of dates between two dates
Date: 2010-02-05 10:06:12
Message-ID: 280998.87159.qm@web31405.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello guys,

can you please help me with the following query

I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this

12/1/2009
12/2/2009
12/3/2009

.
.
.
.
.
12/31/2009

Note : Assume that there is no table

Thanks,
Aravind.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arnaud Lesauvage 2010-02-05 10:35:32 Valid lc-collate names on Windows
Previous Message dipti shah 2010-02-05 09:24:07 Re: Setting permissions to access schema and language