Re: next two mondays
From: Harel Safra <harel.safra_at_gmail.com>
Date: Thu, 07 Jan 2010 07:03:45 +0200
Message-ID: <4B456B31.104_at_gmail.com>
You can use the next_day function:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/functions104.htm#SQLRF00672
Date: Thu, 07 Jan 2010 07:03:45 +0200
Message-ID: <4B456B31.104_at_gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 06 2010 - 23:03:45 CST