Re: date format WW(week number) question

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 26 Sep 1999 16:55:05 GMT
Message-ID: <7slj59$sjr$1@news.seed.net.tw>

guerillot gil <gilgue_at_freesurf.fr> wrote in message news:6i0H3.28876$Ze2.915976_at_nnrp3.clara.net...
> i know only the week number A and the year B.
>
> what kind of sql select query to write for obtain X the first day and Y
the
> last day of the week
> with only the two parameters A and B?
>
> for example A=40 and B=1999.
>
> X=4/10/1999

SQLWKS> select trunc(to_date('19990101', 'yyyymmdd'), 'iw')+40*7 from dual; TRUNC(TO_DATE('19990

---

04-OCT-99
1 row selected.

> Y=10/10/1999 (in french format)

SQLWKS> select trunc(to_date('19990101', 'yyyymmdd'), 'iw')+40*7+6 from dual;
TRUNC(TO_DATE('19990

---

10-OCT-99
1 row selected. Received on Sun Sep 26 1999 - 11:55:05 CDT