Re: SQL: Listing the dates for a particular day of the week in a range
Date: Tue, 16 Dec 2014 20:25:57 +0000
Message-ID: <CAO=9XLzywD9tp8kBn0p8uQ+O79b+UnJxCN_zeOfdCXV-ag7+Lg_at_mail.gmail.com>
Hi Anthony,
Do you mean if start date was say, 1st December and end date was say 31st December and days was M, you want to return the dates of all the Mondays in that set?
Ronan
On 16 Dec 2014 19:52, "Anthony Ballo" <aballo_at_unm.edu> wrote:
> Hello,
>
> I'm working on a scheduling SQL problem. I have a rowset that returns
> "days" with a "startdate" and "enddate".
>
> For example - "days" can have the following values:
>
> Days
> ====
> M
> T
> W
> TR
> MWF
>
> Where: M = Monday, TR = Tuesday & Thursday and MWF = Monday, Wednesday and
> Friday.
>
> What is the best approach to list the appropriate dates of these days
> between the "startdate" and "enddate" range? I would mention that
> "startdate" and "enddate" are the same values for all rows in the rowset if
> that makes a difference.
>
> Any ideas ?
>
>
> Thanks,
>
> Anthony
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 16 2014 - 21:25:57 CET