Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Week numbers and days

Re: Week numbers and days

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 13 Feb 2003 10:34:25 +0100
Message-ID: <1045128663.216854@news.thyssen.com>


"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



05.02.2003 00:00:00

 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US