Postgres Pro
Downloads
Home   >   mailing lists

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

From Ivan Sergio Borgonovo
Subject Re: Query to find list of dates between two dates
Date
Msg-id 20100205130648.2c4ece72@dawn.webthatworks.it
Whole thread Raw
In response to Query to find list of dates between two dates  (aravind chandu <avin_friends@yahoo.com>)
List pgsql-general
Tree view 
On Fri, 5 Feb 2010 02:06:12 -0800 (PST)
aravind chandu <avin_friends@yahoo.com> wrote:

> 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

select
  date '2008-05-01' + i
  from generate_series(0,
  (date '2009-12-10' - date '2008-05-01')) s(i);

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: Re: Query to find list of dates between two dates
Next
From: "Albe Laurenz"
Date:
Subject: Re: How to escape apostrophes when apostrophes already used to escape something else