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
Received on Sat Feb 08 2003 - 19:35:39 CST
