Home > mailing lists

Query to find list of dates between two dates - Mailing list pgsql-general

From	aravind chandu
Subject	Query to find list of dates between two dates
Date	February 5, 2010 07:36:38
Msg-id	280998.87159.qm@web31405.mail.mud.yahoo.com Whole thread Raw
Responses	Re: Query to find list of dates between two dates Re: Query to find list of dates between two dates Re: Query to find list of dates between two dates Re: Query to find list of dates between two dates
List	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.

From: Alban Hertroys
Date: 05 February 2010, 07:17:55
Subject: Re: Literals in foreign key definitions

From: Alban Hertroys
Date: 05 February 2010, 07:55:05
Subject: Re: Query to find list of dates between two dates