Re: Need help with date range inclusion.

lscott_at_crl.com (L. Scott Johnson) writes:

> In article <J3i5Lc1w165w_at_vicuna.ocunix.on.ca>,
> I think you're saying that you want the 'to' date mapped to the closest
> Saturday >= the given date. If so, try:
>
> and start_date <= next_day(to_date(&to_date,'YYMMDD'),'SATURDAY')

Excellent! That is exactly what I needed, thanks... but it brings up another question. I am working on another portion of the script and need the functionality of prev_day (opp. of next_day()). Since SQL*Plus doesn't seem to offer such a function, what is the best way of implementing it?

Thanks again...

---< MAKE MONEY FAST! Contact Dave Rhodes for details. >--- Steve Frampton E-mail: <frampton_at_vicuna.ocunix.on.ca> Received on Thu May 12 1994 - 20:00:28 CEST