Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f54HVrE35018 for ; Mon, 4 Jun 2001 13:31:53 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 66723 for ; Mon, 04 Jun 2001 10:31:52 -0700 From: "Josh Berkus" Subject: SQL Date Challenge To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Mon, 04 Jun 2001 10:31:52 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/20 X-Sequence-Number: 3223 Folks, Can anyone come up with a purely declarative (i.e. SQL) way to SELECT all of the Wednesdays within a given time period? Or is there, perhaps, some trick of the PGSQL date parser I could use? I can think of a number of ways to do this procedurally, but that's very awkward for what I need to use the information (to select all wednesdays within the last two months for which each staff emember has not turned in a timecard). I'm considering using a regularly updated reference table, but it seems like there *must* be a more elegant solution. Basically, what I want is: SELECT ALL Wednesdays BETWEEN 5/1/01 AND 6/1/01; Which results in: Wednesdays ----------- 5/2/01 5/9/01 5/16/01 5/23/01 5/30/01 Thanks for any suggestions! -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco