Re: Date-Week conversion

Joerg; user the ISO year and week date formats. I.E.

   "TO_CHAR(sysdate,'iyyyy-iw')"
This is the ISO standard for week and year.

HTH
James

In article <8p562v$q65$1_at_read01.news.ch.uu.net>,   "Joerg Sobottka" <j.sobottka_at_delta-energy.ch> wrote:
> Hi,
>
> my problem is:
> I get the number of a week and the year, and I need the MONDAY of this
 week.
> The problem is: The 1st of january can be in the last week of the year
> before or it can be in the first week of the new year.
>
> Eg: if I have the week 1 of the year 2000 the monday of this week can
 be the
> dec, 27 1999 or the 3rd of january.
>
> Maybe somebody can help and has build something else.
> Kind regards
> Joerg
>
> ----------------------------------------
> Delta Energy Solution AG
> Lindenhofstr. 28
> 4052 BASEL
> Switzerland
> Tel. : +41-(0)61-283 28 05
> Fax : +41-(0)61-283 28 10
> http://www.delta-energy.ch
> e-mail: j.sobottka_at_delta-energy.ch
>
>

--
Life is complex; it has real and imaginary parts.


Sent via Deja.com http://www.deja.com/
Before you buy.