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
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
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
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