Re: date format WW(week number) question

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Mon, 27 Sep 1999 21:54:05 GMT
Message-ID: <7sop1o$vfp$1@nnrp1.deja.com>

This should help:
SELECT TO_DATE(:b || (:a)*7,'yyrrddd')

(TO_CHAR(TO_DATE(:b || (:a)*7,'yyrrddd'),'d')) + 2 "Beg Date", TO_DATE(:b || (:a)*7,'yyrrddd') + (TO_CHAR(TO_DATE(:b || (:a)*7,'yyrrddd'),'d')) - 2 "End Date" FROM DUAL

James

In article <6i0H3.28876$Ze2.915976_at_nnrp3.clara.net>, "guerillot gil" <gilgue_at_freesurf.fr> wrote:
> 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
> Y=10/10/1999 (in french format)
>
> thanks for help !!!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 27 1999 - 16:54:05 CDT