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

Re: first day of week

From: Volker Graubaum <volker_at_dund-land.de>
Date: Wed, 20 Mar 2002 08:32:28 +0100
Message-ID: <3C983B0C.3F73B8F0@dund-land.de>


Hi Happl,

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

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

thx, that`s what I need :=)

greetings Volker Received on Wed Mar 20 2002 - 01:32:28 CST

Original text of this message

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