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

["David Johnston" <polobo@xxxxxxxxx>]

Start with January 1^st, 2011

Generate Series 0 ~ 200

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

Filter where day(CheckDate) <= 7

Filter where CheckDate <= December 31^st 2013

 

David J.

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Alex -
Sent: Wednesday, May 11, 2011 11:22 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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