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 -> first day of week

first day of week

From: Volker Graubaum <volker_at_dund-land.de>
Date: Tue, 19 Mar 2002 14:57:43 +0100
Message-ID: <3C9743D7.46C408DE@dund-land.de>


Hello,

I need the first day of an Isoweek as date.

I catch the week of a date with

week := to_number(TO_CHAR(mydate4,'IW'));

and the year with

year := to_number(to_char(mydate4,'YYYY'));

then I set

firstweek := week + 1;
firstyear := year -1;

Problems with week = 52 or 53 I will solve myself.

but now I need the date of the firstday in my Isoweek "firstweek" in the year "firstyear".

Who can help?

thx Volker Received on Tue Mar 19 2002 - 07:57:43 CST

Original text of this message

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