Re: Find Number Of Sundays Between Two Dates

From: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Find Number Of Sundays Between Two Dates
Date: 2008-03-05 08:09:49
Message-ID: 200803050809.49902.garry@schoolteachers.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 days
between two years that are important to your application and then just do
simple selects on that table.
Regards
Garry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Suresh Gupta VG 2008-03-05 08:47:30 Meaning og Logs
Previous Message A. Kretschmer 2008-03-05 07:11:14 Re: Find Number Of Sundays Between Two Dates