How to get the last date of a week??

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 28 Jan 1999 08:19:12 GMT
Message-ID: <36b00652.24762534@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!

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Thu Jan 28 1999 - 02:19:12 CST