Re: Week numbers and days

From: Valery V. Tsekhmister <valery_tsekhmister_at_hotmail.com>
Date: Fri, 7 Feb 2003 14:17:39 +0300
Message-ID: <b2083o$ev1$1@slim.sovintel.ru>

Hi Chris !

It's only one pill needed to perform such a conversion:

select next_day(
to_date(substr('200306',1,4),'YYYY')+
(substr('200306',5,2)-1)*7
,'WEDNESDAY') from dual

Regards.

Valery

"Chris Kruiper" <c.a.kruiper_at_home.nl> wrote in message news:mcL0a.1237507$xm4.48152766_at_Flipper...
> Hi,
>
> I want to know the following:
>
> I have a week number in a certain year (format YYYYWW) I want to know what
> date is the wednesday in that week.
>
> Example:
> Year/week: 200306
> Day wednesday
>
> Date: 20020205
>
> Anyone an idea how I can do this from sql?
>
> Thank you,
>
> Chris
>
>
Received on Fri Feb 07 2003 - 05:17:39 CST