Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> first day of week
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