Re: problems with date format

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 02 Dec 1998 22:55:09 GMT
Message-ID: <3665c2e0.12826708_at_news.siol.net>

[Quoted] On Wed, 02 Dec 1998 20:57:51 +0100, Strautmann <stra_at_Strautmann.com> wrote:

>hallo,
>
>How to get a date (the first day of the week) by input the number of
>the week
>for example week 44 get date 26.10.1998

With some basic date arithmetics and functions:

SQL> SELECT NEXT_DAY(TRUNC(TO_DATE('&YEAR','YYYY'),'YEAR')-7   2 + (&WEEK-1)*7, 'MONDAY') FROM DUAL; Enter value for year: 1998
Enter value for week: 44

NEXT_DAY(

---

26-OCT-98 SQL> /
Enter value for year: 1997
Enter value for week: 44

NEXT_DAY(

---

27-OCT-97 SQL>
>thanks

Regards,

Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Dec 02 1998 - 23:55:09 CET