For week = 01 I get
1 select next_day(
2 to_date(substr('200301',1,4),'YYYY')+
3 (substr('200301',5,2)-1)*7
4* ,'WEDNESDAY') from dual
SQL> /
NEXT_DAY(
05-FEB-03
"Valery V. Tsekhmister" <valery_tsekhmister_at_hotmail.com> wrote in message
news:b2083o$ev1$1_at_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 - 08:38:49 CST