Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> REVIEWED: group by week

REVIEWED: group by week

From: andrey <bronfin_at_visualtop.com>
Date: Tue, 5 Dec 2000 20:39:33 +0200
Message-Id: <10701.123700@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C05EFB.79635890 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

  Dear list !

  Is there a function which converts a week number into a date of the first day of the week ?
  For example , this week is week number 49 in the year 2000 .   I need a function that will give me '03-DEC-2000' ( last sunday ) as an output .

  Thanks a lot !

  Andrey .

------=_NextPart_000_0000_01C05EFB.79635890 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">

<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
  size=3D2><BR></DIV></FONT>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D076173218-05122000>Dear=20
  list !</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
  class=3D076173218-05122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D076173218-05122000>Is=20
  there a function which converts a week number into a date of the first = day of=20
  the week ?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D076173218-05122000>For=20
  example , this week is week number 49 in the year 2000 = .</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D076173218-05122000>I=20
  need a function that will give me '03-DEC-2000'&nbsp; ( last sunday ) = as an=20
  output .</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
  class=3D076173218-05122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
  class=3D076173218-05122000>Thanks a lot !</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
  class=3D076173218-05122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
  class=3D076173218-05122000>Andrey =
.</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML> Received on Tue Dec 05 2000 - 12:39:33 CST

Original text of this message

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