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 and

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

[GENERAL] Find Number Of Sundays Between Two Dates

2008-03-04 Thread raghukumar
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... -- View this message in context: http://www.nabble.com/Find-Number-Of-Sundays-Between-Two-Dates-tp15843956p15843956.html Sent from

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