On 3/5/08, A. Kretschmer <[EMAIL PROTECTED]> wrote:
> With generate_series() i generate a list of dates, and later i check if
> the date are a saturday. Okay, you need to know sunday -> change from 6
> to 0 and ou course, you can calculate the parameter for the
> generate_series like
I find it
On Wednesday 05 March 2008 06:16, raghukumar wrote:
> Hai EverBody,
>
> Can I know what is the query by which we can find the number of
> sundays between two given dates in postgres
>
> Thanks In Advance,
> Raghu...
I think the easiest way is to set up a table populated with all dates a
am Tue, dem 04.03.2008, um 22:16:07 -0800 mailte raghukumar folgendes:
>
> Hai EverBody,
>
> Can I know what is the query by which we can find the number of
> sundays between two given dates in postgres
No problem, for instance for month january 2008:
test=*# select count(1) from
(s