Re: next two mondays

From: Michael Fontana <>
Date: Thu, 7 Jan 2010 09:52:49 -0600 (CST)
Message-ID: <>

What environment would you like the shell script to run in?

Solaris, Linux, which shell (bsh, ksh, csh, etc)...

  • Original Message ----- From: "Roger Xu" <> To: "Harel Safra" <> Cc: Sent: Thursday, January 7, 2010 9:37:37 AM GMT -06:00 US/Canada Central Subject: Re: next two mondays

Thanks a lot! (If anyone knows how to do this in a shell script, that will be even better.)

On Wed, Jan 6, 2010 at 11:03 PM, Harel Safra < > wrote:

You can use the next_day function:

Should by something like:
to_char(next_day(sysdate,'MONDAY'),'MMDDYYYY') and

Harel Safra

On 07/01/2010 06:44, Roger Xu wrote:

Hi list,
How do I get the next two mondays in MMDDYYYY format? For instance, if we run the sql today, we want the output to be 01112010 and 01182010. Thanks,
Roger Xu


Michael Fontana

Sr. Technical Consultant

Enkitec M: 214.912.3709



-- Received on Thu Jan 07 2010 - 09:52:49 CST

Original text of this message