Search Postgresql Archives

Re: Query to find list of dates between two dates

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: aravind chandu <avin_friends@xxxxxxxxx>
Subject: Re: Query to find list of dates between two dates
From: Andre Lopes <lopes80andre@xxxxxxxxx>
Date: Fri, 5 Feb 2010 12:01:54 +0000
Cc: postgresql Forums <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <280998.87159.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Query to find list of dates between two dates
  - From: aravind chandu

Prev by Date: Re: Query to find list of dates between two dates
Next by Date: Re: Query to find list of dates between two dates
Previous by thread: Re: Query to find list of dates between two dates
Next by thread: Re: Query to find list of dates between two dates
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux