Re: next two mondays
- From: Michael Fontana <michael.fontana@xxxxxxxxxxx>
- To: wellmetus@xxxxxxxxx
- Date: Thu, 7 Jan 2010 09:52:49 -0600 (CST)
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@xxxxxxxxx>
To: "Harel Safra" <harel.safra@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx > 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
