Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Week numbers and days
"horwinkle" schrieb...
> not even close.
> Do you guys try your stuff before you submit it?
>
Most of the times, not always.
I tested it with the given example, week 6 of year 2003.
This was the result:
10:28:55 po92>select next_day(to_date(substr('200306',1,4),'yyyy')+
10:28:56 2 to_number(substr('200306',5,2)-7),'WEDNESDAY') wednesday from dual;
WEDNESDAY
real: 30
10:28:58 po92>
To me it still looks fine. The OP wanted the date of the wednesday of a given week. That's it. But Scott is of course right, it won't work for e.g. week 1.
And about you and your understandig of Usenet: I agree with Daniel (Next scotch is on me, man!).
Greetings,
Guido
Received on Thu Feb 13 2003 - 03:34:25 CST