Re: next two mondays

From: Roger Xu <wellmetus_at_gmail.com>
Date: Thu, 7 Jan 2010 09:37:37 -0600
Message-ID: <eb64345d1001070737n77cf2d0bj886ea818019cc925_at_mail.gmail.com>

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
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 07 2010 - 09:37:37 CST