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

From: Alex - <aintokyo(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Query to return every 1st Sat of a month between two dates
Date: 2011-05-11 15:22:11
Message-ID: SNT135-w216811A0AC929E9C7FC035CF860@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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
ThanksAlex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-05-11 15:31:15 Re: full text search to_tsquery performance with ispell dictionary
Previous Message Phoenix Kiula 2011-05-11 15:18:35 Regexp match not working.. (SQL help)