From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | SQL Date Challenge |
Date: | 2001-06-04 17:31:52 |
Message-ID: | web-66723@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-06-04 18:02:32 | Re: PGAccess/pgplsql Blues |
Previous Message | Mario Bittencourt | 2001-06-02 22:49:55 | Tutorial : using foreign keys, retrictions etc |