Re: next two mondays

From: Roger Xu <wellmetus_at_gmail.com>
Date: Thu, 7 Jan 2010 10:10:58 -0600
Message-ID: <eb64345d1001070810n8f13221y589727e8c4219a9d_at_mail.gmail.com>

Thanks for every reply. (I was hoping I can accomplish this with ksh in HP-UX.) But that's ok, I can write a small script with the following to get what I want.

SQL> select to_char(next_day(sysdate,'MONDAY'),'MMDDYYYY'),

  2 to_char(next_day(sysdate+7,'MONDAY'),'MMDDYYYY')

  3 from dual;

TO_CHAR( TO_CHAR(

• --------

01112010 01182010

SQL> On Thu, Jan 7, 2010 at 9:59 AM, Radoulov, Dimitre <cichomitiko_at_gmail.com>wrote:

> On 07/01/2010 16.37, Roger Xu wrote:
>
>> Thanks a lot! (If anyone knows how to do this in a shell script, that will
>> be even better.)
>>
> [...]
>
> If you have GNU date:
>
> % date +%d%m%Y -d monday; date +%d%m%Y -d '+1 week monday'
> 11012010
> 18012010
>
>
> Regards
> Dimitre
>
> Linux: $ date –d “next Monday” +%d%m%Y

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

Received on Thu Jan 07 2010 - 10:10:58 CST