Re: Query to return every 1st Sat of a month between two dates

Start with January 1st, 2011

Generate Series 0 ~ 200

Add (Series# * 7) Days to January 1st := CheckDate

Filter where day(CheckDate) <= 7

Filter where CheckDate <= December 31st 2013

David J.

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Alex -
Sent: Wednesday, May 11, 2011 11:22 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Query to return every 1st Sat of a month between two
dates

Hi,

is there an easy way to return the date of every first Saturday of a month
in a data range i.e. 2011-2013

Any help would be appreciated

Thanks

Alex