Re: [GENERAL] Find Number Of Sundays Between Two Dates

2008-03-05 Thread Dawid Kuroczko
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

Re: [GENERAL] Find Number Of Sundays Between Two Dates

2008-03-05 Thread Garry Saddington
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

Re: [GENERAL] Find Number Of Sundays Between Two Dates

2008-03-04 Thread A. Kretschmer
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