Re: first day of week

In article <3C9743D7.46C408DE_at_dund-land.de>,  Volker Graubaum <volker_at_dund-land.de> wrote:

>I need the first day of an Isoweek as date.

select next_day(sysdate, 'Monday') from dual;

>Who can help?

You want the monday of the next week, but from the past year?

select next_day(add_months(sysdate,-12),'Monday') from dual;

Greetings from Switzerland -- Gruesse aus der Schweiz Happl Received on Tue Mar 19 2002 - 10:17:22 CST