Re: next two mondays
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- Date: Thu, 7 Jan 2010 10:10:58 -0600
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@xxxxxxxxx>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
Other related posts:
