Re: How to get the last date of a week??

From: Valery Yourinsky <vsu_at_softexpress.ru>
Date: Thu, 28 Jan 1999 13:20:30 +0300
Message-ID: <36b039ee.0@192.168.2.10>

Violin пишет в сообщении <36b00652.24762534_at_news.twsc.pouchen.com.tw> ...
>Hello,
>Does anyone know how to get the last date of the week?
>
>I could know the first date of the week by trunc function.......
>SQL> select trunc(to_date('19990628','yyyymmdd'),'day') "MON_DATE" from
dual;
>
>MON_DATE
>------------------
>27-JUN-99
>
>But how to get the last date of the week(03-JUL-99)???
>Thank you for your help!

   Simply add 7 days...

SQL> select trunc(to_date('19990628','yyyymmdd'),'day')+7 "MON_DATE" from dual;

                                                       ^^^

MON_DATE

---

05-JUL-99
       ^^
   And remember about year 2000 coming... :-)

Valery Yourinsky Received on Thu Jan 28 1999 - 04:20:30 CST