Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Job to run first Wednesday

RE: Job to run first Wednesday

From: <Jared.Still_at_radisys.com>
Date: Tue, 22 Jul 2003 14:15:58 -0700
Message-Id: <25988.338981@fatcity.com>


Well, this fits the newly clarifed specs. :)

alter session set nls_date_format = 'mm/dd/yyyy';

define testdate = '08/06/2003'

select

Josh Collier <Josh.Collier_at_Banfield.net> Sent by: ml-errors_at_fatcity.com
 07/22/2003 02:24 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


It does appear wrong to me, maybe I am missing something.

if sysdate = August 1, then function should return August 6th (the first Wed
in August) not September 3. By this logic the job would not run in August.

Josh

-----Original Message-----

Sent: Tuesday, July 22, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L

Are you saying 03-SEP-03 is wrong?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

Rachel Carmichael
Sent: Tuesday, July 22, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L

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
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Igor Neyman
  INET: ineyman_at_perceptron.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).
--

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 Received on Tue Jul 22 2003 - 16:15:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US