Hello,
Would this help:
select decode( to_char(last_day(sysdate ),'d'),
6, last_day( sysdate ) ,
next_day(last_day( sysdate ) ,'fri')-7 )
from dual
/
We can do this with:
decode( to_char(last_day( sysdate ),'d'),6,
last_day( sysdate ),4 next_day(last_day( sysdate )
,'fri')-7 )
- lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk> wrote:
> All,
>
> Anyone know how I can select the last Friday in
> every month from dual. I
> just can't seem to figure this out. I am trying to
> test a job that needs to
> be submitted via dbms_job.isubmit on that day.
>
>
> TIA
>
>
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
>
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the
> recipient
> named above, and may be legally privileged. If the
> reader
> of this message is not the intended recipient, you
> are
> hereby notified that any dissemination, distribution
> or
> copying of this communication is strictly
> prohibited.
> If you have received this communication in error,
> please
> re-send this communication to the sender and delete
> the
> original message or any copy of it from your
> computer
> system.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
Received on Tue Jan 23 2001 - 12:18:50 CST
