Re: Query to find list of dates between two dates

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: aravind chandu <avin_friends(at)yahoo(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query to find list of dates between two dates
Date: 2010-02-05 12:01:54
Message-ID: 18f98e681002050401qbf7fd27r21320ddf8d8d85b7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You could use a query like this one here:

and table.BEGIN_DATE <= pREFERENCE_END_DATE
and (table.END_DATE >= pREFERENCE_BEGIN_DATE or table.END_DATE is null)

Best Regards

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2010-02-05 12:06:48 Re: Query to find list of dates between two dates
Previous Message Alban Hertroys 2010-02-05 11:54:50 Re: Query to find list of dates between two dates