don't rush off to use it..... I tried it, substituting August 1 and got
September.
1* select
next_day(last_day(to_date('08/01/2003','MM/DD/YYYY')),'WED') from dual
SQL> /
NEXT_DAY(
03-SEP-03
- Jared.Still_at_radisys.com wrote:
> Hmm... much more elegant than mine, and everyone elses.
>
> Guess I better RTFM the next_day function.
>
>
>
>
>
>
> "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
> Sent by: ml-errors_at_fatcity.com
> 07/22/2003 12:34 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: Job to run first Wednesday
>
>
> Josh,
>
> With the following functions, you could probably get it to work:
>
> select next_day(last_Day(sysdate),'WED') from dual
>
> This (today) returns Wed, August 6th.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Tuesday, July 22, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Greetings,
>
> How can I set the interval in my dbms job to have it run on the first
> Wednesday of every month? Is this even possible? I have been trying
> to
> noodle it thru for a week to no avail.
>
> tia,
>
> Josh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Josh Collier
> INET: Josh.Collier_at_Banfield.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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!?
Received on Tue Jul 22 2003 - 14:18:45 CDT