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-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alex - Sent: Wednesday, May 11, 2011 11:22 AM To: pgsql-general@postgresql.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
