Re: next two mondays

From: Michael Fontana <michael.fontana_at_enkitec.com>
Date: Thu, 7 Jan 2010 09:52:49 -0600 (CST)
Message-ID: <15601020.29001262879569246.JavaMail.root_at_mail.enkitec.com>

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

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

• Original Message ----- From: "Roger Xu" <wellmetus_at_gmail.com> To: "Harel Safra" <harel.safra_at_gmail.com> Cc: oracle-l_at_freelists.org 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 < harel.safra_at_gmail.com > wrote:

You can use the next_day function:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/functions104.htm#SQLRF00672

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

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

enkitec

oracle_certified_partner

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 07 2010 - 09:52:49 CST