Postgres Pro
Downloads
Home   >   mailing lists

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

From Andre Lopes
Subject Re: Query to find list of dates between two dates
Date
Msg-id 18f98e681002050401qbf7fd27r21320ddf8d8d85b7@mail.gmail.com
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
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


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Query to find list of dates between two dates
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Query to find list of dates between two dates