Re: Week numbers and days

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Fri, 7 Feb 2003 13:14:45 +0100
Message-ID: <1044619922.598866@news.thyssen.com>

"Valery V. Tsekhmister" wrote...
> 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

Hi Valery,

not quite right, I think.

Maybe:

select next_day(to_date(substr('200306',1,4),'yyyy')+ to_number(substr('200306',5,2)-7),'WEDNESDAY') from dual;

will do it.

Nice weekend to everyone,
Guido Received on Fri Feb 07 2003 - 06:14:45 CST