Re: Week numbers and days

horwinkle wrote:

> Doesn't work ... not even close.
> Do you guys try your stuff before you submit it?
>
> Guido Konsolke wrote:
> > "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

Insulting those that try to help is a sure way to get none.

Most of the time solutions provided are based upon trying to interpret a request and many, if not most requests, contain some degree of ambiguity. Some are so ambiguously written that no answer is possible: Only questions. Some of the time we make mistakes. No one here is claiming perfection AFAIK. But certainly there is a more civil way to indicate that a solution provided by someone, donating their personal time for no reason other than a desire to be helpful, didn't work.

Based on the above ... I won't even try to help. So at least one bridge has been burned.

Daniel Morgan Received on Sun Feb 09 2003 - 00:30:14 CST