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: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 22 Jul 2003 12:18:45 -0700 (PDT)
Message-Id: <25988.338958@fatcity.com>


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!? Received on Tue Jul 22 2003 - 14:18:45 CDT

Original text of this message

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