Postgres Pro
Downloads
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
Msg-id 280998.87159.qm@web31405.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Query to find list of dates between two dates  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: Query to find list of dates between two dates  (Andre Lopes <lopes80andre@gmail.com>)
Re: Query to find list of dates between two dates  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Re: Query to find list of dates between two dates  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Literals in foreign key definitions
Next
From: Alban Hertroys
Date:
Subject: Re: Query to find list of dates between two dates